1.
Description
Description
While creating the reports, it is important to put the input
parameter(s) in the sequential order based on the business requirement(s). If
any change request comes to change the sequence of the input parameter(s) in
SSRS report, then it can be changed easily.
parameter(s) in the sequential order based on the business requirement(s). If
any change request comes to change the sequence of the input parameter(s) in
SSRS report, then it can be changed easily.
Sample Report with Input parameter(s):
In the below Report, sequence of parameter is MonthèQuarterèWeekè Year
If the business requirement is to have Year first as parameter
then we can change it using Report designer or Report Builder
then we can change it using Report designer or Report Builder
2.
Steps to change the sequence of the parameter(s):
Steps to change the sequence of the parameter(s):
a.
Go to the Report designer or Report builder
Go to the Report designer or Report builder
b.
Go to the report data region by pressing CTRL +
ALT + D
Go to the report data region by pressing CTRL +
ALT + D
c.
Go to the Parameter section
Go to the Parameter section
d.
Select the parameter for which you want to
change the sequence e.g. Year
Select the parameter for which you want to
change the sequence e.g. Year
e.
Click on the Move Up Or Move Down button to set
the required sequence
Click on the Move Up Or Move Down button to set
the required sequence
f.
In the below example, Year parameter is at Last
in the sequence so select the Year parameter & click on Move Up till It
will reach to top
In the below example, Year parameter is at Last
in the sequence so select the Year parameter & click on Move Up till It
will reach to top
g.
Now Year should display at Top in the Parameter
list
Now Year should display at Top in the Parameter
list
Also put Quarter at second position
h.
Now Preview the Report
Now Preview the Report
We should be able to see Year parameter at first position then Quarter
————————————End of the Article———————-