Excel
Video

Adding Parameters to Report and Datasets

Lesson 10 Chapter 4

This video is part of the video course:
FREE Professional & Paginated Excel Reports without Power BI

When we are creating Paginated Reports in most situations we want to add the ability to the users to dinamically shows the data in the Excel Report.

That is why we need to add parameters to our Paginated Reports.
This parameter we will later use to pass to the report the value so that it can filter the data that we are using in the Report and show only the data that the user wants in the Paginated Report.

The parameter needs to be added in the Microsoft Report Builder to the Report but also we need to pass this parameter to the Dataset so that only the data will be show in the report that is based on this parameter.

Pen