Report with multiple columns won't print in portrait

I have a report that has 6 columns and won't print in potrait mode. I have
set the page width to 8.5in and the page height to 5in. If I set the page
height to 11in it prints OK (but I need to limit the height to 5in.
Also, can I use this report as the report source for a subreport control?
Thanks,On Sep 11, 1:59 pm, "Tim Kelley" <tkel...@.company.com> wrote:
> I have a report that has 6 columns and won't print in potrait mode. I have
> set the page width to 8.5in and the page height to 5in. If I set the page
> height to 11in it prints OK (but I need to limit the height to 5in.
> Also, can I use this report as the report source for a subreport control?
> Thanks,
You might try modifying the Report Properties Layout, if you haven't
already: via: Layout view -> Report drop-down -> Report Properties... -
> Layout tab -> Page height:, Top margin:, Bottom margin:. If you are
using columns, reduce the Spacing: property. For the subreport
control, you can use the report; however, it it has report columns,
once it is exported it will remove the columns automatically. This is
evidently a flaw in the export functionality. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

report viewer height problem!! in IFRAME

Any body has problems using report viewer in IFrame? Here is the observation i have....when you assign the report.Height = 400px. It is assigning the report body height to be 400px. when i say report body I mean report body only!!

The report parameters section is not included in 400px. The export, print, page navigation button sections is not in 400px either!! Given such properties, when you want to show report viewer in a pre-determined IFRAME (non-scrollable) height of 500px, part of the report and horizontal report scroll bar could disappear , if the paratemeters section is more than 100px (says >2 rows or more than 4 parameters)!!

can someone tell me how to lock the height of report viewer size that will include parameters + export,print + report body? or any workaround?

I remember hearing this somewhere before. I have not tried this in your situation, but can you set the value to 100%?|||tried set to 100%.....does not work.sql