views:

1807

answers:

2

Hi,

I have a SSRS report. I am using grouping and my report is having n number of pages. Is it possible to have the html display of the report in a single page with out page break and the exported version( pdf, excel) have the page break). Any idea. Please share some thoughts.

Thanks in advance Anna

A: 

What version of SSRS? 2008 lets you specify a different page size for interactive and regular paper (ie the html version will render different than say PDF).

keithwarren7
its version 2005
+2  A: 

Short answer: Set the InteractiveHeight = 0

According to Microsoft:

Soft page breaks are calculated at run time by the control. Although it is not recommended, you can disable soft page breaks by setting InteractiveHeight to 0.

InteractiveHeight and InteractiveWidth are used by the HTML rendering extension to provide the equivalent of PageHeight and PageWidth. Because the HTML output format dynamically resizes a report to accommodate drilldown, drillthrough, and show/hide features, the report server uses different properties to support pagination on dynamic pages.

EDIT Comment Answer:
In the Layout mode, bring up Properties panel. At the top of the Properties panel is a drop down to select which control's properties you are looking at, select Report You will then find “Interactive Size” that includes Interactive Height property.

Dustin Brooks
Where can i find this property
Edited answer for this question
Dustin Brooks
Thanks for the location. I was about to start throwing things at my monitor because I couldn't find it :)
paulwhit