1. Background
The purpose of this article is to describe a way of sorting
report data at tablix level. We are going to use Tablix’s sorting property to sort
report data by multiple fields.
2. Step by Step procedure to sorting the data using tablix property:
·
Below is the sample report
in which we will add filters to limit the data:
·
Go to Sorting
and click on “Add” to add the fields
by which we need to do sorting. Here we are going to sort data by FiscalYear
(Descending Order) and SalesRegion (Ascending order)
·
Now run the report
Here we can see that report is showing data that is
sorted by Fiscal Year (Descending order) and Sales Region (Ascending order).
3.
Conclusion
By using the above steps, we can sort the data at tablix level or report
level in SSRS.
----------------------------------------------------End
of Article---------------------------------------------------
No comments:
Post a Comment