any report footer

Hello,

I need to build a report that list customer payable with invoice and date detail. Now create a report by putting customer name in page area so that I can get a report per customer. At the bottom of this report for each customer I need to repeat customer name and total amount and other information. That is why I put it into page footer, it works fine if the report is only one page per customer, if it is more than one page, first page does not show total amount, second page does not show customer name. How can I fix this problem?

Re: any report footer

you could use Table footers instead of Page footers.

Re: any report footer

Thanks for the input ndinakar.

I already have a total field in table footer and summing columns. I still need to put total amount and customer name at the bottom of page, customer name and address should got to a specifics area on the page since it goes to an envelop and be visible to outside. Is there any way I can keep customer name and address as an global variable and use it at to bottom of each page.

Re: any report footer

If it something that should go in the bottom of each page then it has to be put in table footer. I have worked with RS extensively for a few months in my previous project and we have statements that we mail out to customers. We ended up having tables and tables in the body section. Even the copyright part of the page was put in the table footer. Since the contents of the copyright notice change and we didnt want to hard code and we have a limitation from the RS about using fields in the footer.

Re: any report footer

Hello ndinakar,

I really appreciate your input, it is very helpful. I am new in RS and I am really trying to do the same thing as you did. I have the following questions and would like to see your comments.

I added a table in body section but how can I make sure that it goes to the bottom of the page, for some customers I may have only 2 lines, for some I may have 10 lines. What should I do to put table at the bottom of the page.
We are using this envelope that shows customer address bottom right, so I need to put customer name and address bottom right so that when page is folded it goes to right spot. How do you handle this part in your system?
If you have more than one page statement per costumer, do you have page number? If yes, how did you handle it?

Thanks,

Re: any report footer

<div>We had a huge group of nested tables.table around table..and table around table...and it was very painful when we created it. Even slight modifications had to be very carefully tested. So its mostly trial and error.
For page numbers I think there is some Globals!PageNumber that can be used. You can also use Globals!TotalPages. Sorry if I havent been of much help. </div>