Andy Williams
Andy Williams

Reputation: 907

Dynamic Page Break on SSRS Report based on Parameter Selection

Currently SSRS Report is grouped by the following in the Row Group. When I export the report to excel it is broken into tabs by that ID. I am now passing a Parameter to the report that if set to false, the exported excel report should return only one tab. After doing a little research created an expression in the PageBreak Disabled Property. Whenever I run the report now no matter if I set the parameter to True or False it only returns a single tab. Can anyone offer any insight? THanks!

enter image description here

[![enter image description here][2]][2]

enter image description here

enter image description here

Upvotes: 1

Views: 1224

Answers (1)

Andy Williams
Andy Williams

Reputation: 907

.Data File strikes again. Cleared cashe the expression worked.

Upvotes: 1

Related Questions