SSRS 2012 Interactive Reports--Interactive sorting

SSRS Interactive Reports-- Interactive Sorting

In the process of viewing data, sorting actions are unavoidable in order to quickly identify specific information and confirm the relative size of the data. However, different analysts face different usage habits and analysis purposes, and report data must be sorted in ascending or descending order with different fields. SSRS provides a handy "interactive sort" feature that allows the user to specify field collations in the report, as long as the interactive Sort tab in the Properties window is set.

Interactive Sort Example

Step 1 :

First, make a sales report (in ProductCategory as a group), showing both the sales amount and the quantity sold. Right-click the "Sales Amount" header and select "Text box Properties ...". Tick "Enable Interactive sorting on this text box" and click "Groups" in the Sort area and select the "Productcategory_name" group from the drop-down menu.

650) this.width=650; "title=" clip_image002 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;margin:0px;border-left:0px;padding-right:0px; "Alt=" Clip_ image002 "src=" http://s3.51cto.com/wyfs02/M02/59/7C/wKioL1TUdRuylA3kAAGaVj-Ss5w979.jpg "border=" 0 "height=" 550 "/ >

Step 2 :

Next, in the "Sort by" input "=sum (fields! Sales_amt. Value) ", note that since our sort is based on" Groups "rather than detailed data, you must not directly select" Sales_amt "Using the drop-down menu directly. Value ", otherwise the system will be sorted according to the amount of sales in the detail (based on a single pen) rather than the sum of the sales amounts for the group (based on the group totals), resulting in a sort error.

650) this.width=650; "title=" clip_image004 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;margin:0px;border-left:0px;padding-right:0px; "Alt=" Clip_ image004 "src=" http://s3.51cto.com/wyfs02/M00/59/7C/wKioL1TUdRyjDpTRAAF6DQJlRCA103.jpg "border=" 0 "height=" 525 "/ >

Step 3 :

Preview the report when you're done, and you'll see two small triangles appear at the header you just set, and the data will automatically switch to ascending or descending order as soon as you click. In addition to sorting within a data region, if a dataset is shared by multiple different data regions, it can also be a reason to grieve the ability to synchronize interactive sorting to synchronize different data regions that share the same dataset. This feature is mostly used for interaction between data tables/matrices and icons.

650) this.width=650; "title=" clip_image006 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "alt=" clip_image006 "src=" Http://s3.51cto.com/wyfs02/M01/59/7C/wKioL1TUdR3jFIeEAACc6Kf7trs330.jpg "border=" 0 "height=" 181 "/>

This article is from the SQL Server deep dives blog, so be sure to keep this source http://ultrasql.blog.51cto.com/9591438/1612414

SSRS 2012 Interactive Reports--Interactive sorting