Report Footer/ Page Footer Section
I am using Data Reports for one of my Invoicing application.
I need to print the Total Amount always at the end of the report. I have placed the controls in the Page Footer section of the report, but if my report is greater than One page then it prints the Total Amount on all the pages which I don't want. It should only print at the last page.
If I try to place the controls in the Report Footer section, then it prints the Total Amount when ever the report is finished(middle of the page). But I want this to be printed at the bottom of the page.
I hope you have got the problem.
Anyone pls help...
Thanks in advance..
Rohit
Re: Report Footer/ Page Footer Section
Re: Report Footer/ Page Footer Section
I can't remember the exact syntax. But... Go to the section expert ( for report footer) and in the formula area do something like 'suppress when pagenumber <> max pages.'
Re: Report Footer/ Page Footer Section
Thanx Pasvorto for ur reply.
I am using Data Reports and can you tell me how can I go to the Section expert in that...
Re: Report Footer/ Page Footer Section
I was thinking that you were using Crystal Report Writer. My bad. I've not used Data Reports so I guess I can't be of much help.
1 Attachment(s)
Re: Report Footer/ Page Footer Section
Hi Pasvorto,
Its seems that u are a CR Writer.
Can my problem be solved if I create my report in Crystal instead of Data Report. I haven't worked in Crystal Report, so I would be helpful if you could let me know...
Pls find the attached zip file which contains the generated Data Report (with problem) exported into html form. I want Page Footer to be printed only on the last page of the report. I am printing the report on the pre printed stationary.
Regards,
Re: Report Footer/ Page Footer Section
Yes, it can be done in CR. I have never fooled around with Data Reporter so I really can't make too much use of your code. I have a number of reports (invoices,etc) that do totally on different pages.
Here's some code from the group footer that goes to another page if a given line number is reached, so it won't overwrite to "totals" boxes. (New Page After)
/code
WhilePrintingRecords;
numberVar linecount ;
linecount := 1;
not OnLastRecord;
/code
Here's where it prints each line, in the Detail section (New Page After)
/code
WhilePrintingRecords;
global numberVar linecount ;
linecount := linecount + 1;
if linecount > 29 then linecount := 1;
if linecount > 28 then true;
/code
Hopefully this gives you some idea.
Re: Report Footer/ Page Footer Section
I came to the conclusion that its not possible in Data Report.
I have started learning Crystal Report. Thanks for ur piece of code...
I have designed a simple report in CR, but when I am trying to run it from VB then it gives me a error "SQL Server not open."
Can u tell me where I am going wrong?
Regards,
Re: Report Footer/ Page Footer Section
What level of CR are you running? It makes a difference.
Re: Report Footer/ Page Footer Section
I would be using CR 7.0
Also I want to one thing, can I set the data to the text obj in any section through VB.
Regards,