I am using SSRS 2016 and Report Builder. I need the page breakinging with a group to be conditional on the value of a parameter. Does anyone know if this is even possible?
How to achieve conditional page breaks in SSRS 2016
report-builderssrs
Related Question
- SQL Server – Cannot Login from Visual Studio but Works on SSRS Page
- Sql-server – SSRS make a conditional format on the column
- Report Builder Installation – Fixing DLL Error During Report Builder CTP 2.3 Installation
- Differences between SSRS 2016 and Report Builder 2016
- SSRS Label Orientation
- SSRS – : How to make a conditional formatting for matrix by group
- SSRS : How to give parameter values in URL Http requests
Best Answer
Another workaround, which seems to work quite nicely - place a parent group of the group you want to selectively break on, then in Group Properties for that, group on a derived expression of either the group field, or a fixed value. And then tick the box for that grouping as per your screenshot.
e.g. Assuming a parameter called "BreakPages", and a grouping on a field called "MyGroupField", you group on:
You don't need to display any fields in this special group, it'll simply use the page break setting as per your requirements..