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. :D

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.