Report has paging even with interactive size zero 0 in SSRS

reporting paging reporting-services reportingservices-2005
Devin Burke picture Devin Burke · Feb 28, 2012 · Viewed 8.9k times · Source

I have a report in SSRS 2005 that consists of three subreports, all four of which have their interactive size set to zero. The three subreports are contained in a list. However, the report still pages (verb) at what looks like 8.5in X 11in. The paging is not due to page breaks because there are none and sometimes the reports cut off in the middle and continue on the next page.

What else causes paging besides the interactive size?

UPDATE: I am referring to web pages specifically. The printed/exported size works fine.

Answer

M.C.Rohith picture M.C.Rohith · Mar 7, 2012

I can see that the "Page Size" prorperty also matters apart from the "Interactive Size".

Set the "Height" property under "Page Size" property for the main report that contains the subreport as "455" inches that is the maximum size for the page height. If the data is more than that then it will be in the other page I think we cannot avoid this.

Related questions

The permissions granted to user ' are insufficient for performing this operation. (rsAccessDenied)"}

I created a report model using SSRS (2005) and published to the local server. But when I tried to run the report for the model I published using report builder I get the following error. Report execution error:The permissions granted …

Read More
SSRS expression to format two decimal places does not show zeros

I am using the following expression to format my value to show only two decimal points. Which Works fine if the value is not 0. However when the value is 0 it does not show 0. eg. Expression used =Format(Fields!CUL1.Value, "##.##") …

Read More
Passing parameter via url to sql server reporting service

I'm trying to pass a parameter via the url to SSRS and it appears not to work! I'm trying to pass a userId (string) via the url which will be passed to the database and used by the query. base …

Read More