Problem: How to add
parameters in an SSRS Report?
Parameters are useful in a report to filter values based on
the selection of inputs of various parameters.
Some useful examples of using parameters in the SSRS Report
are as follows:
1.
Select number of orders on a day.
2.
Number of orders based on the items selected.
3.
Can be useful for filtering and slicing the
report data.
If you want to know how to launch and create a basic report Create
a report SQL Server
Example:
In the example, I would like to show we can add parameters
to a report.
Step 1: On the top section of the design you can add a
parameter by right clicking on boxes or go to the report data and in the
parameters selection add new parameter.
Step 2: Set properties for the parameters to use the values
from dataset
Output:
As you can see there is multiselect of dates in the orders
and filter orders based on the date selection.
0 comments:
Post a Comment