SSRS 2008 PageBreak based on parameter from end user

Question

SSRS 2008 PageBreak based on parameter from end user

BICoolGal

Old Hand

Points: 326
More actions
January 15, 2014 at 3:40 pm

#396114

Hi SSRS experts,
Iam working on SSRS 2008 report where I need to allow user the option to pick "yes" or "no" for the page break. I have only one tablix in the report, when "yes" is selected, I need to add a page break(which is adding another worksheet/tab in an excel). When "no" is selected, I don't want any page break.
Here are what I have set up but it does not work for me.
Create a report parameter name PageBreak, value "yes" and "no"
On a tablix property, under 'PageBreak', I put "Between" in 'BreakLocation' field
and I put "False" in 'Disabled" field.
On a Group properties/Tablix Member, Under 'Group', Under 'PageBreak', I put "None" in 'BreakLocation' field and put
=iif(Parameters!Page_Break.Value="no",true,false) in 'Disabled' field.
This does not work, so I tried all combinations and it is still not working.
Can someone please help me how to implement the page break based on the parameter from the user? Thanks so much.
LL
Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

mister.magoo SSC-Forever Points: 47174 More actions · Answer 1

You have to get a bit inventive and add a parent group to your tablix, with an expression for the "group" value that evaluates to blank for no paging and evaluates to the "group" value of your existing group when the paging parameter is true...then set paging "between" on that parent group.

Bit hard to follow? Take a look at the attached sample rerport - it is self contained and will run without a database connection. 😀

Note: I had to zip it as this forum won't let me upload an rdl.

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

BICoolGal Old Hand Points: 326 More actions · Answer 2

Thank you so much MM. It is working now, yay. I only need to set one expression =IIf(Parameters!Page_Break.Value = "no", true, false) in 'Disabled field' at the group level and put 'Between' in 'BreakLocation' field and it works! perfect!

mister.magoo SSC-Forever Points: 47174 More actions · Answer 3

Great! Thanks for the feedback.

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);