Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2005
    Location
    Lynnwood, WA
    Posts
    4

    Unanswered: subtotals by page

    Hello,
    I have a report that has several pages of values per group. I am trying to determine how to get a subtotal for each page that is generated instead of only having a subtotal at the end of each group. I have tried the keep together and new page options, but that doesn't seem to be working.
    We are using version 10 professional.
    Any ideas?

    Thanks in advance

  2. #2
    Join Date
    Oct 2003
    Posts
    357
    Hi,
    Do you want to generate pagewise total?

    Madhivanan

  3. #3
    Join Date
    Feb 2005
    Location
    Lynnwood, WA
    Posts
    4
    Yes. I would like to generate a subtotal by page.

  4. #4
    Join Date
    Oct 2003
    Posts
    357
    Hi,

    You need to use three formulae

    Formula 1 : @Reset
    NumberVar x;
    WhilePrintingRecords;
    x:=0;

    Formula 2 : @Sum
    NumberVar x;
    WhilePrintingRecords;
    x:=x+{DatabaseFiled};

    Formula 3 : @Display
    NumberVar x;
    WhilePrintingRecords;
    x

    Place Formula1 in Page Header and suppress
    Place Formula2 in Details section and suppress
    Place Formula3 in Page Footer and Dont suppress

    Madhivanan

  5. #5
    Join Date
    Feb 2005
    Location
    Lynnwood, WA
    Posts
    4
    That did the trick. Thank you very much

  6. #6
    Join Date
    Jul 2007
    Posts
    1
    Thanks, Madhivanan.
    This is cool technique.

  7. #7
    Join Date
    Feb 2009
    Posts
    23
    thanks Madhivanan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •