I have a requirement which group summary should be displayed in the report footer. for example
column1 column2
a 10
a 15
b 10
b 11
b 22
c 20
c 24
d 25
if i do group by column 1 group summary for a=15 for b=43 for c=44 d 5 and it is dispalyed in group footer but i need to display it in report footer how could i achieve this?
When you insert summary, by default it is inserted in the Report Footer unless you specify the group levels where you want the summary to be placed.
There are two things you can do
When inserting summary, accept the default Summary location which is “Grand Total (Report Footer)”. This will insert the summary in the Report Footer. If you need the summary to be inserted in all group levels + Report Footer, simply select “Add to all group levels”
If you already have the group summary, just drag your existing group summary into the Report Footer. Or copy and paste it in the Report Footer if you need them in both group and Report Footer.