SSRS Page break in subreport - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

SSRS Page break in subreport

Author

Topic

pssumesh2003
Starting Member

35 Posts

Posted - 2011-09-26 : 12:59:23

Hi all

I have one table report in SSRS 2005, and it consists of one sub report in the detail section in the main report. i want to break the main report,if the row number in the sub report exceeds 25 rows, ie breaks the main report at every 25 th row of the second report.

Plz help me....

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-26 : 13:28:34

add a grouping based on RowNumber(nothing)/26 function and then select property put a page break for the group

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

pssumesh2003
Starting Member

35 Posts

Posted - 2011-09-26 : 14:07:09

THANKS

but where it i add group .
In SubReport or main report?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-26 : 14:12:56

subreport as thats one which renders data

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources