Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2009
    Posts
    23

    Question Unanswered: Subtotal of Group

    How to make subtotal of GroupS?

    I am using Crystal Report XI. Before i was able to make subtotal of records per page, Amount and Quantity are place in Details section then subtotal is place in page footer. But after i place Amount and Quantity in Group Footer2, subtotal had an stange computation, i doesnt read the first record.

    example:

    Row Quantity Amount
    1 -----> 1---------100
    2 -----> 2---------1000
    3 -----> 3---------100
    4 -----> 5---------500
    ----------------------------------------
    ----------10--------1600 ------------>> Subtotal
    ----------11--------1700 ------------>> Grand Total

    Here is my code WHEN IT IS WORKING FINE

    Located at pageHeader

    Code:
    numberVar y ;
    WhilePrintingRecords;
    y := 0;
    LOCATED AT dETAILS

    Code:
    NumberVar y;
    WhilePrintingRecords;
    y:=y+{Table1.Quantity};
    LOCATED AT pAGE FOOTER

    Code:
    NumberVar y;
    WhilePrintingRecords;
    y


    Here is my code WHEN IT IS WORKs sTRANGE

    Located at pageHeader

    Code:
    numberVar y ;
    WhilePrintingRecords;
    y := 0;
    LOCATED AT Group Footer2

    Code:
    NumberVar y;
    WhilePrintingRecords;
    y:=y+{Table1.Quantity};
    LOCATED AT Group Footer1

    Code:
    NumberVar y;
    WhilePrintingRecords;
    y

    I have noiced that when i suppress Details section the error occur but when it isnt suppress/hide the subtotal is ok.....

    thanks for any correction and comments
    Last edited by kristle.sison26; 04-20-09 at 05:35.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    WhilePrintingRecords... If they are supressed, surely they are not printing?
    George
    Home | Blog

  3. #3
    Join Date
    Feb 2009
    Posts
    23
    thanks,

    have changed some formula and it work when i preview its result in crystal report app, but when i use the app i did same problem occur..

Posting Permissions

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