Options

grouping data in integer data item in last of report

ahmedbaahmedba Member Posts: 424
hi guys i make report as title daily receipt report this report consist of two tables

G/L Account

G/L Entry

this report as following

posted date g/l account no document no amount

12/03/2012 12 15 150

12/03/2012 12 16 200

12/03/2012 12 17 200

12/03/2012 13 18 300

12/03/2012 13 19 400

i make this report but what i need is to display total for every group in footer section or last of report but not after every group as following
:

12/03/2012 12 15 150

12/03/2012 12 16 200

12/03/2012 12 17 200

12/03/2012 13 18 300

12/03/2012 13 19 400

12 550

13 700

how i make this as above i make this before by group footer but it display after every group but not suitable solution for me.

so that what i need is to add integer data item in last of report this data item make grouping to evey group in report how i make this
and what i write of code in data item integer .
please help me

thanks

Comments

  • Options
    MBergerMBerger Member Posts: 413
    Try using the "date" virtual dataitem. With the right setting you'l be able to get a record per day ( i am assuming that is what you want ). You'l probably will have to add the same calculations and/or code as you had for the first sections of your report.

    Another way would be to use a temporary table for totalling and add your numbers to that during the first pass, then use an integer dataitem to display what s in the tempraryo table afterwards.

    btw, your example data seems to be wrong, you are showing a total for 13, but there are no lines with 13 in your example.
  • Options
    SavatageSavatage Member Posts: 7,142
    Do you always have to see all the Line Details?

    Perhaps you can add a "Detail" or "Summary" option to the Options tab of the report.

    If they select Summary you only see the Group Totals by controlling what is shown.
    If the user wants to see all the entries that created the total they can hit detail.

    IE/ See Aging Reports.

    PrintDetail type Boolean
    OnPreSection()
    CurrReport.SHOWOUTPUT := PrintDetail;
Sign In or Register to comment.