Conditional Page Break

Question

Post reply

Conditional Page Break

dspenst

Old Hand

Points: 309
More actions
November 24, 2008 at 2:26 pm

#196215

Can SSRS 2005 do conditional page breaks?
I want to only do a page break when a certain condition occurs.
E.g. New page when report being sent to customers. One customer per page.
For in house use just one long report with more than one customer per page.
Can this be done or is there are work around?
Thanks,
Doug

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Niraj-627298 Hall of Fame Points: 3641 More actions · Answer 1

Hi dspenst,

I guess we can acheive this...by following few steps as follows;

1> Create a report level parameter giving end users an option to select no. of rows to be printed...say...only 1 per customer or 10 or 25 or All...

eg. Parameter Name is RowsNo.

2> Now, create a group and write an expression stating;

=Ceiling(RowNumber(Nothing)/Parameters!RowsNo.Value)

Remove Header and Footer if not required to avoid white spaces.And set the page break at end ...

3> So...this will generate no. of rows as selected in RowsNo. parameters.

I hope..this should help...:)

Thanks,

Niraj

checkai Hall of Fame Points: 3041 More actions · Answer 2

I have also seen the use of a rectangle with a conditionally shown/hidden rectangle within it. This method has worked for me on occassion but is very finicky. Surprisingly, I don't believe this issue is fixed in the 2008 version either.

Jerry Hung SSChampion Points: 12968 More actions · Answer 3

checkai (12/4/2008)
I have also seen the use of a rectangle with a conditionally shown/hidden rectangle within it. This method has worked for me on occassion but is very finicky. Surprisingly, I don't believe this issue is fixed in the 2008 version either.

I can confirm on that SSRS 2008 doesn't have this page break idea, let alone conditional page break

Unless I miss it completely that someone can point out where...

SQLServerNewbieMCITP: Database Administrator SQL Server 2005

sgmunson SSC Guru Points: 110640 More actions · Answer 4

The only reliable way to control page breaks with Reporting Services is to find a way to create a field that you can use to group by. There's no reason that a field value can't be "conditional" within a query. Folks use the CASE statement for this kind of thing all the time. What MS may be trying to do is force more set-based thinking...

Steve

(aka smunson)

:):):)

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

SomeOtherGuy Valued Member Points: 67 More actions · Answer 5

I know a very late reply, but for the people who also searching for page break solutions I have found some solutions which I know they will work.

For people like me for who are still using ssrs 2005, some solutions needs to be modified a bit to get it work.

Conditional page break:

http://social.msdn.microsoft.com/Forums/en-US/2f09b99b-bec2-443d-b78a-308d83132200/conditional-page-breaks-in-ssrs

Group page break:

1. http://social.msdn.microsoft.com/Forums/sqlserver/en-US/413bdaa9-a579-4461-8e51-e90233939edb/problem-with-rownumber-page-break?forum=sqlreportingservices

2. http://www.spacefold.com/lisa/post/2009/03/08/Dynamic-Page-Breaks-in-SSRS-Going-to-Eleven.aspx

Limit records per page with page break:

http://www.sqlservercentral.com/Forums/Topic490774-147-1.aspx