Sunday, December 09, 2012 6:21 AM
Monday, December 10, 2012 3:32 AMModerator
Based on your description, there are 12 columns in the report and you want to filter columns based on the parameter. In order to meet your requirement, we specify the visibility of the columns based on the values of the parameter.
For example, create a parameter named “Column-name” and specify the available values for the parameter with the 12 column names. And then, in report designer surface, specify the column visibility of each column as follows:
The following thread is about the same issue, please refer to:
For the second question, please try to create a group that contains details records add a group expression to group by a specify number of rows. And then a page break to the group. For example:
The expression results in a page break every 20 rows.
For more details, please refer to the page break section of the following article.
TechNet Community Support