| Author |
Topic |
|
sz1
Aged Yak Warrior
555 Posts |
 Posted - 2012-11-21 : 04:40:51
|
| I have a simple 2 column table, one column with category and nthe other with a count of all category items, I want to sort the count column from highest to lowest Z-A...I'm sure this is simple enough but where do I set the value for this. Sorting on the tablix only shows the field values?Thanks |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-11-21 : 06:49:17
|
| Don't sort on the tablix level. Sort on the group. Right-click the group, Group Properties -> Sorting tab. |
 |
|
|
sz1
Aged Yak Warrior
555 Posts |
Posted - 2012-11-21 : 06:56:34
|
| I right clicked under Row Groups and went to Group Properties - sorting but dont see an option for the Total field/column? the column is just an expression: =Count(Fields!Call_ID.Value) |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-11-21 : 07:35:48
|
| Row Groups -> right click the group, -> Group Properties -> Sorting tab -> Add -> click expression button, -> select Datasets in category -> select Count(Call_ID) -> OK. |
|
|
|
sz1
Aged Yak Warrior
555 Posts |
Posted - 2012-11-21 : 07:47:11
|
| Nice, thank you...! |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-11-21 : 08:38:31
|
| you are very wlecome.) |
|
|
|
sz1
Aged Yak Warrior
555 Posts |
Posted - 2012-11-21 : 10:02:28
|
| Not sure if I should raise a new topic but I now have a 2 table column with categories and the correct amount on the total column in desc order. What I would really like to do is only show the top 6 categories but use an interactive sort for users to be able toclick the 6th record and expand the rest of the table to shopw rest of categories, is this possible?Thanks |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-11-21 : 11:51:17
|
| On the design surface, select the row, right click, row visibility, show or hide based on an expression, insert expression such as "=Fields!RankColumn.Value > 6"You can also use the "Display can be toggled by this report item" to toggle the display. Create another textbox and use that as the toggle item. So when the user clicks on the text box (which you can set up to look like whatever you want), the display will toggle. |
|
|
|
sz1
Aged Yak Warrior
555 Posts |
Posted - 2013-01-08 : 07:06:33
|
| Thanks again!SZ1Learning and development is the driving force in the universe...! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-01-09 : 00:06:48
|
| http://sqlserverpedia.com/blog/sql-server-bloggers/visibility-settings-in-ssrs-drill-down-to-showhide-report-data/------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
sz1
Aged Yak Warrior
555 Posts |
Posted - 2013-01-09 : 02:45:12
|
| Thank you!SZ1Learning and development is the driving force in the universe...! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-01-09 : 22:55:37
|
| welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
Sort by Sum Column