| how to check supplier name in a page is same or different in the next page [message #315259] |
Sun, 20 April 2008 09:46 |
vinoth_kumar
Messages: 4
Registered: July 2006
|
Junior Member |
|
|
Hi All,
I have an issue in supplier snapshot report.
1st page
Supplier Name: XYZ
Opening Balance:10
Balance in Period:100
Closing Balance:110
2nd page
Supplier Name: XYZ
Opening Balance:10
Balance in Period:200
Closing Balance:210
I have used Formula Columns to calculate Opening Balance(Outstanding Payment to Supplier before From_Date) & Balance in Period (Outstanding Payment to supplier for the period(From_Date to To_Date) which the report is run).
Closing Balance = Opening Balance + Balance in Period
Now the issue is if the supplier invoice and payment details is in one page then it is printing correctly.If the details extends to more than one page then the opening balance is getting repeated in the other pages.
User needs an o/p like this.
1st page
Supplier Name: XYZ
Opening Balance:10
Balance in Period:100
Closing Balance:110
2nd page
Supplier Name: XYZ
Opening Balance:0
Balance in Period:200
Closing Balance:200
How to check for the supplier names getting repeated or not between pages.
I tried in between_pages trigger but it is not allowing me to reference the supplier_number or supplier_name field.
Thanks in Advance.
kumar
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
