Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 671
  • Last Modified:

Page Header/Footer in a subreport

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
dorint
Asked:
dorint
  • 7
  • 5
1 Solution
 
bdreed35Commented:
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
 
dorintAuthor Commented:
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
 
DsanasCommented:
have you tryed to break the page footer by the format section. so when a formula its true makes the page break?.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
dorintAuthor Commented:
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
 
dorintAuthor Commented:
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
 
bdreed35Commented:
I Am going to take a look at this further today to see if we can't get you a resolution.  Stay Tuned
0
 
dorintAuthor Commented:
Thank you for your reply bdreed35. Hopefully you help me to get this issue solved.
0
 
bdreed35Commented:
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
 
dorintAuthor Commented:
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
 
bdreed35Commented:
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
 
dorintAuthor Commented:
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
 
bdreed35Commented:
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
 
dorintAuthor Commented:
Thank you for all the comments that I received for this question.
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 7
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now