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?
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.
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.
***********************
Dinakar Nethi
Life is short. Enjoy it.
***********************
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?
<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>
***********************
Dinakar Nethi
Life is short. Enjoy it.
***********************
JIM.H.
Contributor
2316 Points
565 Posts
any report footer
Jul 06, 2005 03:38 PM|LINK
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?
ndinakar
All-Star
49092 Points
6868 Posts
Moderator
MVP
Re: any report footer
Jul 06, 2005 06:40 PM|LINK
Dinakar Nethi
Life is short. Enjoy it.
***********************
JIM.H.
Contributor
2316 Points
565 Posts
Re: any report footer
Jul 06, 2005 06:51 PM|LINK
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.
ndinakar
All-Star
49092 Points
6868 Posts
Moderator
MVP
Re: any report footer
Jul 06, 2005 11:16 PM|LINK
Dinakar Nethi
Life is short. Enjoy it.
***********************
JIM.H.
Contributor
2316 Points
565 Posts
Re: any report footer
Jul 07, 2005 12:12 PM|LINK
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.
Thanks,
ndinakar
All-Star
49092 Points
6868 Posts
Moderator
MVP
Re: any report footer
Jul 07, 2005 06:48 PM|LINK
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>
Dinakar Nethi
Life is short. Enjoy it.
***********************