Home » Developer & Programmer » Reports & Discoverer » how to check supplier name in a page is same or different in the next page (Reports 6i)
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




Previous Topic: lov find of parameter report
Next Topic: Discoverer Admin. Reports
Goto Forum:
  


Current Time: Thu Dec 08 14:32:42 CST 2016

Total time taken to generate the page: 0.18125 seconds