dorint
asked on
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
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
ASKER
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
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
have you tryed to break the page footer by the format section. so when a formula its true makes the page break?.
ASKER
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.
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.
ASKER
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
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
I Am going to take a look at this further today to see if we can't get you a resolution. Stay Tuned
ASKER
Thank you for your reply bdreed35. Hopefully you help me to get this issue solved.
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?
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
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.
I can think of a possibility of a workaround, but it would be onvolved.
ASKER
Thank you for all the comments that I received for this question.
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.