Skip to Content
author's profile photo Former Member
Former Member

Page size on unlinked subreports

I have a requirement to combine 3 existing reports into one report. The reports are not linked. So, I've started with two. I opened the first report and saved it with a new name. I inserted a subreport in the report footer section. I get one report after the other as expected but the second subreport insists on being 8.5 X 11 even though the original report it was created from uses 11X17 just like the first report. Since both reports use 11X17 why is the subreport appearing with a different page size? That makes it truncate a whole lot of data I need in the report. I don't care how wide the report is as both of these reports are never printed, only downloaded into Excel.

I should add that if I am active on the subreport tab and check page size it says 11X17. There is no place that says 8.5X11 for the subreport.

How do I fix this?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Feb 08, 2012 at 10:32 PM

    Yes, when you insert a sub-report into the Main report the horizontal size of the subreport shrinks, although the sub-report's page size could be larger.

    After you insert the Subreport in the Main report just increase the horizontal size of the subreport, just like you would increase the size of a normal field.

    -Abhillash

    Add a comment
    10|10000 characters needed characters exceeded

    • Yes, the Page Setup for the subreport will say 11/17. When you place it on the Main report it comes in as a long object with a default Width of 7.069. Right-click the Subreport and go to size and position and increase this value or you can increase the size of the field by pulling the field towards right just like you would normally do with a database/formula field.

      -Abhilash

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.