Report Footer/ Page Footer Section

[mehtarohit]

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

[mehtarohit]

Pls Help...

[Pasvorto]

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.'

[mehtarohit]

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...

[Pasvorto]

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.

[mehtarohit]

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,

[Pasvorto]

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.

[mehtarohit]

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,

[Pasvorto]

What level of CR are you running? It makes a difference.

[mehtarohit]

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,