Positioning parameters

It is true that most of the formal reports (or production report) are parameterized. We add parameters to the report for making it look dynamic and flexible without making it a static report. Therefore, report parameterization is one of the key features in designing, hence it needs flexibility.

Since Reporting Services inception, we can add parameters to reports. Parameters are shown in a layout that is fixed for two columns. We have no way of changing the position we need, but it allows us to change the order. A parameter pane in a report with one or two parameters does not look unorganized, but a pane with more than two parameters may look disorganized and untidy. Assume that you have a report that shows City, Start Date, ...

Get SQL Server 2016 Reporting Services Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.