Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
filip1150
Starting Member
2 Posts |
 Posted - 2009-04-14 : 09:39:58
|
| Hi All,I have a very simple scenario.I have a tablix with 3 levels of aggregation, each of them having running totals.For instance, assume I have something like Region/Country/City and a dollar figure for each city, which gets aggregated at country and region level. I want to add interactive sorting so the user can click on the dollar column header and sort by it. Proper sorting for me is to order each group, each subgroup within the group and each detail row.The most I can get is to have the groups sorted, but data within the group remains unsorted. Is it even possible to do this?much appreciated |
|
|
Kokkula
Starting Member
41 Posts |
Posted - 2009-04-15 : 03:52:51
|
| Hello,Select the textbox on which you want to apply interactive sot and select properties of that cell. In that go to the Interactive Sort tab and apply the ineractive sorting on that table on the required field.Hope its clear and helpful...Thanks,Pavan |
 |
|
|
|
|
|
Interactive sorting