O'Reilly logo

SQL Server 2016 Reporting Services Cookbook by Robert C. Cain, Dinesh Priyankara

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required