How to get a Sum of rows, when i use the property max. rows p. page ?

Advertisement
November 30

Hi all.
I've got a query and get a lot of rows (amounts) back.
Now i want to have max. 21 rows per page.
So, first i used the property "max. rows p. page"=21.
But i want a have Sum-Field p.page too, which shows the sum of the amount p. page at a >fixed place (bottom, left) at the page.
this didnt work well....
Because when i have 30 rows, then the sum will shown at the second page (because the sum-field its after the repeating frame).
...Now i forgot the property and placed a function and two placeholder in the query like this:
Function:
:cp_row:=:cp_row +1;
if (mod (:cp_row,21)=0)) then :CP_pagenr:=:CP_pagenr+1;
Placeholders: cp_row, cp_pagenr
Now i want to use :CP_pagenr to change the group - but Report Builder says: I cant... because placeholder are not allowed to change a group.
So.. perhaps anyone can give me a hint how i can do this ?
Thanks a lot...

Advertisement

Replay

hello.
that sound to me as you wanted a running total. check out the metalink knwoledge base and search for running total and you will find a note on how to do that.
regards,
the oracle reports team --pw                                                                                                                                                                                                                                                                                                                                                                                                                                       

View 2 Replies

Tags:

  1. cfl on pdf text box in sap
  2. ke30 report currency
  3. sap note 1113277
  4. BExGetData
  5. backup-spsite when to use sqlsnapshot
  6. UAFT
  7. throughoutrpq
  8. smallestdky
  9. 9J18
  10. smileaqq
Copyrights 2019 Fcffair BigData Resource, All rights reserved