Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How do I eliminate repeating subreports?

Posted on 2009-05-14
6
Medium Priority
?
403 Views
Last Modified: 2012-05-07
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
Comment
Question by:jsmith08
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 24390182
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
 
LVL 2

Assisted Solution

by:vetaldj
vetaldj earned 500 total points
ID: 24390194
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
 
LVL 5

Assisted Solution

by:dhobale
dhobale earned 500 total points
ID: 24390289
0
Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

 
LVL 101

Assisted Solution

by:mlmcc
mlmcc earned 500 total points
ID: 24390739
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
 

Author Closing Comment

by:jsmith08
ID: 31581715
Thanks everyone for this information...I have a much better understanding of how this works now.
0
 

Author Comment

by:jsmith08
ID: 24397564
I added report footer sections for each of the subreports and it is working fine...thanks again.
jsmith08
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

650 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