Repeat the group footer band on each page

Stimulsoft Reports.WPF discussion
Shaimaa
Posts: 11
Joined: Thu Feb 01, 2018 3:08 pm

Repeat the group footer band on each page

Post 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.
Attachments
Capture.PNG
Capture.PNG (56.22 KiB) Viewed 5766 times
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Repeat the group footer band on each page

Post 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.
Shaimaa
Posts: 11
Joined: Thu Feb 01, 2018 3:08 pm

Re: Repeat the group footer band on each page

Post by Shaimaa »

Hello,
Thanks for your quick reply, i'm gonna prepare a report with sample data as soon as possible.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Repeat the group footer band on each page

Post by HighAley »

Hello.

We are waiting for a sample.

Thank you.
Shaimaa
Posts: 11
Joined: Thu Feb 01, 2018 3:08 pm

Re: Repeat the group footer band on each page

Post by Shaimaa »

Hello
Attachments
Classeur2.xlsx
(219.28 KiB) Downloaded 325 times
SamplReport.mrt
(45.04 KiB) Downloaded 343 times
Lech Kulikowski
Posts: 6243
Joined: Tue Mar 20, 2018 5:34 am

Re: Repeat the group footer band on each page

Post by Lech Kulikowski »

Hello,

You can use the Footer component for this task.
Please check the modified report.

Thank you.
Attachments
SamplReport_modified.mrt
(47.1 KiB) Downloaded 355 times
Shaimaa
Posts: 11
Joined: Thu Feb 01, 2018 3:08 pm

Re: Repeat the group footer band on each page

Post 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,
Lech Kulikowski
Posts: 6243
Joined: Tue Mar 20, 2018 5:34 am

Re: Repeat the group footer band on each page

Post 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.
Shaimaa
Posts: 11
Joined: Thu Feb 01, 2018 3:08 pm

Re: Repeat the group footer band on each page

Post 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
Attachments
Classeur2.xlsx
Data
(219.28 KiB) Downloaded 261 times
SamplReport.mrt
Report
(46.64 KiB) Downloaded 246 times
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Repeat the group footer band on each page

Post 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.
Attachments
GroupSumRunning.mrt
(789.76 KiB) Downloaded 357 times
Post Reply