[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

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

How do I eliminate repeating subreports?

Hello Experts,
I have two subreports each in its own page header section of a main report.  The report includes a parameter to prompt the user to select which report they would like to view. When I run the report for more expansive date ranges, I receive the following error message:  "The page size was not large enough to format the contents of an object in the report."  I tried placing the subreports in separate detail sections thinking that the problem might be that I put the subreports in page header sections of the main report, but then the subreports are repeated multiple times.  The only data being displayed in the main report is the two subreports.  Is there a way around this problem?  It appears that this error message comes up if the subreports exceed one page.  I've also noticed that for some reason my page footer sections in the subreports have disappeared after being added to the main report??
0
jsmith08
Asked:
jsmith08
4 Solutions
 
peter57rCommented:
A page header cannot exceed the page size so if there is a possibility that the subform might do that it's in the wrong place.
Use the Report Header or footer instead.
0
 
vetaldjCommented:
Problem here not in report header section. Putting them to detail section will not help as it will run it for each record you have in your data set and that's why you receive multiple subreports. You need to play with settings on Format Subreport option, Common tab.
0
 
dhobaleCommented:
0
Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

 
mlmccCommented:
A page header is just that a header for the page which means it must fit on the page and leave room for the page footer.  If should also leave room for the some of the rest of the report so it can finish.

Putting the subreport in the detail section causes it to be run for each record in the main report recordset.  Unless it is linked to that record it generally is not a good idea to have subreports in the detail section.

Put one in the report header the other in the report footer.

Subreports do not have page headers and footers.  They must be controlled by the main report.

There are tricks to getting fake page headers and footers in a subreport if you really need them.

A page header is just that a header for the page which means it must fit on the page and leave room for the page footer.  If should also leave room for the some of the rest of the report so it can finish.

Fake page headers in a subreport
https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes_boj/sdn_oss_boj_erq/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/scn_bosap/notes%7B6163636573733d36393736354636443646363436353344333933393338323636393736354637333631373036453646373436353733354636453735364436323635373233443330333033303331333233313330333933383336%7D.do

Fake page footers  in a subreport
https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes_boj/sdn_oss_boj_erq/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/scn_bosap/notes%7B6163636573733d36393736354636443646363436353344333933393338323636393736354637333631373036453646373436353733354636453735364436323635373233443330333033303331333233313336333533353334%7D.do

mlmcc
0
 
jsmith08Author Commented:
Thanks everyone for this information...I have a much better understanding of how this works now.
0
 
jsmith08Author Commented:
I added report footer sections for each of the subreports and it is working fine...thanks again.
jsmith08
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

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