mibuso.com

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 .what i need to show report 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 to display total for every group
i added but after added i insert g/l entry in this section of body of integer but result display as 0 and repeated more time why and how i solve proplem
please help me

thanks

Just adding an integer dataitem won't automagically create the grouping that you want. You have to think your way through this type of development task. If it were me I would probably think of something like a temporary table to store these group totals, and figure out a way to have a dataitem at the end either based on that temporary table or some other way to have the data out of the temporary table display in a regular body section.

You've been at this for weeks now, when are you going to get some help from a senior, or get a developer from your partner to do this for you? You won't get full on instruction from forums like this, you need someone to sit down with you and show you how to do this.

Your question is not much clear but as far as i understand based on your report output you want to print total document wise at the end of report or at footer place.
for this take a another GL Entry dataitem without any indentation having grouping on document no. and print only group footer section with total of amount field.

Do not forget to assign all filters to this dataitem that you have been applied above same dataitem.

this is good but what i write in filter to make grouping