Home » Developer & Programmer » Reports & Discoverer » Reports 6i - Calculation on Pagination
Reports 6i - Calculation on Pagination [message #325489] Fri, 06 June 2008 06:06 Go to next message
apps.sudhir
Messages: 2
Registered: 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.

Thanks in Advance.

Regards
Sudhir
Re: Reports 6i - Calculation on Pagination [message #325716 is a reply to message #325489] Sun, 08 June 2008 01:52 Go to previous messageGo to next message
dude4084
Messages: 222
Registered: 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 Go to previous message
apps.sudhir
Messages: 2
Registered: May 2008
Location: Bangalore
Junior Member
Hi mate,

It's working fine now.
THANKS FOR YOUR HELP. Smile

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


Current Time: Wed May 15 13:25:03 CDT 2024