Home » Developer & Programmer » Reports & Discoverer » Reports 6i - Calculation on Pagination
Reports 6i - Calculation on Pagination Fri, 06 June 2008 06:06
 apps.sudhir Messages: 2Registered: May 2008 Location: Bangalore Junior Member
Hi,

This is a Report Builder 6i query. Let me brief you the scenario.

Lets suppose there is a repeating frame D in which there are 3 fields A,B and C resp.

Assumption: Initial value of A = 0 and B = 10 (static value)
"C" is the summation of "A" and "B". (C = 0+10 = 10).

When we execute the report, report output should be:

Page 1 should display : A = 0, B = 10, C = 10 (A + B = 0+10)

Page 2 should display : A = 10, B = 10, C = 20 (A + B = 10 + 10).
(Here in page2, the value of "C" from page1 (which is 10) is carried forward to the value of "A" in page2.).

Page 3 should display : A = 20, B = 10, C = 30 (20+10)
(Here in page3, the value of "C" from page2 (which is 20) is carried forward to the value of "A" in page3.).

These values should get refreshed for each repeating frame ("D").

Help appreciated.

Regards
Sudhir
Re: Reports 6i - Calculation on Pagination [message #325716 is a reply to message #325489] Sun, 08 June 2008 01:52
 dude4084 Messages: 221Registered: March 2005 Location: Mux Senior Member
Hi

I have made a sample report for you on the basis of your requirement which will give you guideline to meet your objectives. Please note that I have used scott's EMP table.

Kindly see attachment
-Dude
Re: Reports 6i - Calculation on Pagination [message #325833 is a reply to message #325716] Mon, 09 June 2008 02:23
 apps.sudhir Messages: 2Registered: May 2008 Location: Bangalore Junior Member
Hi mate,

It's working fine now.

Regards
Sudhir
 Previous Topic: Page not displaying Next Topic: Format mask for Char Fields
Goto Forum:

Current Time: Fri Jul 28 12:26:41 CDT 2017

Total time taken to generate the page: 0.13254 seconds