Solved

Page Header/Footer in a subreport

Posted on 2004-09-22
14
650 Views
Last Modified: 2008-01-09
Hello guys,

I have two reports with Page Header and Footer and I inserted them in a master report in the Report Footer. The Page Header and the Page Footer in those two subreports became Report Header and Footer. (subreports can not have Page Header and Footer). What is the workaround to have something similar with PH and PF in a subreport.
I use this solution to print an invoice in two copies: one is the Original and the other one is the Customer Copy. (so I use two subreports for this). I have only one group – for invoice number - and everything is fine when details do not exceed one page because the header and the footer will be printed at the beginning and at the end for each group. The problem appears when I have more then two pages for one invoice because I cannot have the page header on the second, third, etc page and the page footer on the first, second, etc. page.
Any suggestions or a solution will be greatly appreciated.
Thank you in advance for your help.

Best Regards,
Dorin
0
Comment
Question by:dorint
  • 7
  • 5
14 Comments
 
LVL 28

Expert Comment

by:bdreed35
ID: 12123954
This might work for you:

http://support.businessobjects.com/library/kbase/articles/c2005103.asp

If you have any other questions after you have read the article, post them and we can help you work through them.
0
 

Author Comment

by:dorint
ID: 12131732
Thank you bdreed35 for your prompt reply. The link helped me only with the Header section of the subreport.
Regarding the Footer I still have problems with the last page of the invoice group when the number of records is similar with the one specified to print under detail section. In this case it will print the detail section which acts as a fake page footer instead of  the report footer (or Group Footer in my case) and also on the next page will print what I have under Group Footer. So I will have for ex. 4 pages instead of 3 and the totals will not be printed on the third page. I would like to mention that some fields on the detail and group footer sections have formulas to suppress them. Basically on each page where the detail fake footer is printed one text field will be displayed and on the last page of the group the totals will be displayed.
The other problem is related to the lines that are used as delimiter for invoice columns - they will be printed in the detail section used as fake page footer.
Any suggestions solving those problems will be appreciated.

Thank you,
Dorin
0
 

Expert Comment

by:Dsanas
ID: 12131757
have you tryed to break the page footer by the format section. so when a formula its true makes the page break?.
0
 

Author Comment

by:dorint
ID: 12150356
I am still waiting for a solution.
The article http://support.businessobjects.com/library/kbase/articles/c2014229.asp regarding the fake Page Footer in a subreport did not take into consideration the case when on the last page we have the similar number of records with the one defined to print under detail section on each page. (see my previous comment). In this specific case it wil print both the fake page footer and the Report Footer on the next page.
0
 

Author Comment

by:dorint
ID: 12367155
Hello,
I did not forget about my question but I was still waiting for a solution. The comment from bdreed35 helped me partially with my problem. So if you have to close this question you can give to bdreed35 150-200 points from the total of 400 points assigned to this question.
Regards,
Dorin
0
 
LVL 28

Expert Comment

by:bdreed35
ID: 12368728
I Am going to take a look at this further today to see if we can't get you a resolution.  Stay Tuned
0
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 

Author Comment

by:dorint
ID: 12369012
Thank you for your reply bdreed35. Hopefully you help me to get this issue solved.
0
 
LVL 28

Expert Comment

by:bdreed35
ID: 12369032
Dorin, is this only happening when the max number of details is reached on that page?  Is there any extra space for the remaining sections to print on the same page as the last detail?
0
 

Author Comment

by:dorint
ID: 12369212
You are right. This is happening only when the max number of details is reached on that page. For ex if I have the max setup for 30 and I have 60 details then the fake page footer will be printed on the second page and the report footer on the third page. The same thing happen if I have only 30 details - fake page footer will be printed on the first page and the report footer on the second page.
0
 
LVL 28

Accepted Solution

by:
bdreed35 earned 400 total points
ID: 12369360
Ok this is what I did:

Open the Section Expert.
Highlight Details (not a or b, but just Details) and click the X+2 button to the right of New Page After.
Change the logic to this:

Remainder(RecordNumber, 30) = 0 and
not onlastrecord

Save and Close.
Next, highlight Details b and click the X+2 to the right of Suppress (No Drill Down).
Change the logic to this:

Remainder(RecordNumber, 30) <> 0 or
onlastrecord

Save and Close.
Next, highlight Report Footer a and click the X+2 button to the right of Suppress (No Drill Down).
Delete any logic you have in there.  You don't need it as it will only print at the end of the report anyway.
Save and Close.

That is all I had to do with the sample that I created.  Let me know if you have any other issues.
0
 

Author Comment

by:dorint
ID: 12370459
Evrika. It is working. Thank you very much. One more thing I would like to clarify. If one field in the Detail section is setup to grow (Can Grow option is checked on the Common Tab from Format Object) then this solution with Fake Page Footer is not working. Am I right? There is another workaround for this situation?
0
 
LVL 28

Expert Comment

by:bdreed35
ID: 12370555
Well, you can add the Can Grow to the Details A, but depending on how much your fields grow, it will change how much data will fit on a page, throwing off the fake page footer.
I can think of a possibility of a workaround, but it would be onvolved.
0
 

Author Comment

by:dorint
ID: 12370642
Thank you for all the comments that I received for this question.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now