SSRS
Interactive Reports--
Synchronizing Interactive sorting
Step 1 :
First, drag a "chart" in the "Interactive sort" sample report just now, set it as a bar chart, drop the sales amount, the sales quantity from the Report Data window to "Values", and drag and drop the product category into the "category Groups" area.
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/80/wKiom1TUdIPyLwgKAAI4Ldlkoc8703.jpg "border=" 0 "height=" 439 "/ >
Step 2 :
Go back to the text box that just set the interactive sort, turn on the TextBox property, tick "Apply this sorting to all groups and data regions in:" and enter the data set name "Sales parameterized Report" for two data region shares directly in the drop-down menu, To complete the synchronized interactive sorting settings.
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/80/wKiom1TUdITRAJSmAAI3BwgV5bc308.jpg "border=" 0 "height=" 528 "/ >
Interactive sort synchronization
Note that if two data regions are to be set to synchronize interactive sorting, the use of datasets and the group definitions used must be consistent.
Step 3 :
Preview the report when the settings are complete, and as soon as you click the Interactive Sort feature on the datasheet, the data in the icons on the right side of the screen will be sorted in ascending or descending order.
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/80/wKiom1TUdIXgcaRXAALpRPTht_Y377.jpg "border=" 0 "height=" 538 "/>
The designer can set the scope of the interactive sorting according to the requirement, in order to achieve the elasticity demand, please note! If you want to use interactive sorting, you cannot set "sorting" in a Tablix or in a group because the system takes precedence over the "sorting" setting, which results in an inability to achieve interactive sorting.
This article is from the SQL Server deep dives blog, so be sure to keep this source http://ultrasql.blog.51cto.com/9591438/1612418
SSRS 2012 Interactive Reports-Synchronous interactive sorting