how to show entire report in single page using Report Builder?

sql-server-2008 ssrs-2008 reportbuilder3.0
Ujjwal picture Ujjwal · Jun 7, 2013 · Viewed 17.3k times · Source

I am using MS Report builder 3.0 to create one of my report.The report is the tabular report and sometimes the size of table grows long about 2 to 3 pages. But i want to show the entire report with in single page without having to click next page button. I tried increasing page size but that doesnot work. Please help! I am new to Report Builder.

Answer

Ian Preston picture Ian Preston · Jun 7, 2013

It sounds like you need to set the InteractiveSize -> Height property to 0cm:

enter image description here

This will prevent implicit page breaks when viewed in Report Manager or a ReportViewer control.

This won't have any effect on printing, exporting to PDF, etc, as these media have to force page breaks no matter what - they're affected by the PageSize properties.

Related questions

SSRS Query execution failed for dataset

Have just deployed my Project on to my reporting Server. I have multiple datasets which are referencing views which exist on the db on that server. When I try to go into any report part I am getting this message: …

Read More
Reporting Services permissions on SQL Server R2 SSRS

I'm getting the error below when I try and access SSRS on SQL Server 2008 R2 I'm not sure how many others have started using SQL 2008 R2 SSRS, but I am having an issue with getting the error below when I …

Read More
Using the IN operator to filter in reporting services

Can anyone advise what the syntax should be when using the IN operator within a table filter. I have tried the below but the snytax is wrong:

Read More