Repeat the group footer band on each page
Repeat the group footer band on each page
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.
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 (56.22 KiB) Viewed 5766 times
Re: Repeat the group footer band on each page
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.
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
Hello,
Thanks for your quick reply, i'm gonna prepare a report with sample data as soon as possible.
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
Hello.
We are waiting for a sample.
Thank you.
We are waiting for a sample.
Thank you.
Re: Repeat the group footer band on each page
Hello
- Attachments
-
- Classeur2.xlsx
- (219.28 KiB) Downloaded 325 times
-
- SamplReport.mrt
- (45.04 KiB) Downloaded 343 times
-
- Posts: 6243
- Joined: Tue Mar 20, 2018 5:34 am
Re: Repeat the group footer band on each page
Hello,
You can use the Footer component for this task.
Please check the modified report.
Thank you.
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
Re: Repeat the group footer band on each page
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,
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,
-
- Posts: 6243
- Joined: Tue Mar 20, 2018 5:34 am
Re: Repeat the group footer band on each page
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.
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
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.
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.
- Attachments
-
- Classeur2.xlsx
- Data
- (219.28 KiB) Downloaded 261 times
-
- SamplReport.mrt
- Report
- (46.64 KiB) Downloaded 246 times
Re: Repeat the group footer band on each page
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.
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