Page 1 of 2
Repeat the group footer band on each page
Posted: Thu Mar 22, 2018 3:41 pm
by Shaimaa
I have created a stiReport that consists of a detail band, surrounded by Group Headers and Footers.
I need to repeat the Group Footer on each page. In the designer, the only option available is for repeating the Group header.
My report structure is :
PageHeader
GroupHeader2
GroupHeader1
DetailBand
GroupFooter1
GroupFooter2
PageFooter
I want to print for each page the the GroupFooter1 with the value of {SumRunning(GroupHeaderBand1,Value)}.
Does anyone knows how to repeat the Group Footer on each page.
P.S : I've tried to use a footer band, it's true that i can show my band on each page, but i wasn't able to get a SumRunning foreach group.
Many thanks in advance.
Re: Repeat the group footer band on each page
Posted: Fri Mar 23, 2018 11:45 pm
by HighAley
Hello.
It's impossible to print Group Footer on each page.
It should be a Footer Band.
Could you send us your report with sample data with description?
Thank you.
Re: Repeat the group footer band on each page
Posted: Wed Mar 28, 2018 7:47 am
by Shaimaa
Hello,
Thanks for your quick reply, i'm gonna prepare a report with sample data as soon as possible.
Re: Repeat the group footer band on each page
Posted: Wed Mar 28, 2018 9:01 pm
by HighAley
Hello.
We are waiting for a sample.
Thank you.
Re: Repeat the group footer band on each page
Posted: Thu Mar 29, 2018 3:31 pm
by Shaimaa
Hello
Re: Repeat the group footer band on each page
Posted: Tue Apr 03, 2018 7:05 am
by Lech Kulikowski
Hello,
You can use the Footer component for this task.
Please check the modified report.
Thank you.
Re: Repeat the group footer band on each page
Posted: Thu Apr 05, 2018 8:05 am
by Shaimaa
Hello
Thanks for your reply.
The Footer component can be useful if i'm trying to get a SumRunning foreach page or all the report, the probleme here is that i need SumRunning foreach GroupHeaderBand1.
After all, i think that it's impossible to repeat the group footer on each page.
Thank you,
Re: Repeat the group footer band on each page
Posted: Fri Apr 06, 2018 5:16 pm
by Lech Kulikowski
Hello,
Unfortunately, in this case only Footer.
As a way, you can try to use an additional variable to calculate the necessary sum.
Thank you.
Re: Repeat the group footer band on each page
Posted: Mon Apr 09, 2018 8:40 am
by Shaimaa
hello,
I try to use an additional variable (SumReport) to calculate the necessary sum as you said.
The variable is initialized to 0 after each GroupHeaderBand1 andto ReportSum = ReportSum + (double)(Journal.Debit) after Data band is rendered.
So ReportSum has the value of the cumulation of 'journal.Debit' , what i need it's to add to this value the value of cSum(journal.Debit) , but after adding it i got only the value of cSum(journal.Debit) as if ReportSum = 0 but it's not the case.
Many thnaks for your kind support and assistance.

Re: Repeat the group footer band on each page
Posted: Mon Apr 09, 2018 3:49 pm
by HighAley
Hello.
The cSum() function is calculated in post-processing.
The Footer band with Print on All Pages = True behaves different way.
Please, look at the attached report template. You could find there a sample with sums for each group.
Thank you.