| Invert |
Interactive Sorting?
Hi,
We are trying to evaluate this control for one of our customer wherein they have a requirement of soring the data on various columns in report.
One of the feature of Silverlight Report viewer control for SSRS 2008 is interactive sorting. Can you please explain what is it about and how it works?
Regards
Badal
|
Irina Sabaeva
08/12/2010 02:57
Interactive Sorting?
Hello,
Interactive Sorting means that you can click on column headings and have the report automatically sort by that column.
This option can be set in rdl-report (for example, in Report Builder for Reporting Services) and it is supported by Silverlight Viewer for Reporting Services.
Open your rdl-report, right click the Tablix header cell of column that you would like to have sortable and select the Text Box Properties from the context menu. Click on the Interactive Sort link on the left hand side of the opened window and check the ‘Enable Interactive Sorting in this textbox’ check box. In Sort by property select the mentioned column.
If you preview the report in the SL Viewer, you’ll notice that the column has a couple of arrows in the header. So, by clicking on it, you can dynamically change the sort order of the rows in your report viewer.
Best regards,
Irina Sabaeva
PerpettumSoft Support Team
|
Interactive Sorting?
But i think this is the functionality offered only when user chose to edit the report in report builder (to be specific report builder 3.0) which in our case is not an option... business wants this to be part of the application and do not want to leave the application.
Also Report builder 3.0 (i guess) does not along with SSRS 2008 / 2008 R2 and is available as a separate download right? Is there any way to integrate Report builder 3.0 in place of what SSRS default Report builder?
Regards
Badal
|
Irina Sabaeva
08/13/2010 02:04
Interactive Sorting?
Hello!
Our component (Silverlight Viewer for Reporting Services) allows the display of this functionality, which you should specify during the creation your report.
You can create reports in Report Builder (1.0-3.0) released together with SQL Reporting Services 2008 and used as default in SSRS. Also reports can be designed using Visual Studio 2008 with the included as installed plug-in Business Intelligence Projects: create a new Report Server Project, add a Tablix and do all mentioned actions to set the interactive sorting for columns.
You can see detailed information about it here:
http://msdn.microsoft.com/en-us/library/cc627509.aspx
Best regards,
Irina Sabaeva
PerpetuumSoft Support Team
|