| Author |
 Topic  |
|
|
sz1
Constraint Violating Yak Guru
United Kingdom
294 Posts |
 Posted - 11/21/2012 : 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
Flowing Fount of Yak Knowledge
5152 Posts |
Posted - 11/21/2012 : 06:49:17
|
| Don't sort on the tablix level. Sort on the group. Right-click the group, Group Properties -> Sorting tab. |
 |
|
|
sz1
Constraint Violating Yak Guru
United Kingdom
294 Posts |
Posted - 11/21/2012 : 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
Flowing Fount of Yak Knowledge
5152 Posts |
Posted - 11/21/2012 : 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
Constraint Violating Yak Guru
United Kingdom
294 Posts |
Posted - 11/21/2012 : 07:47:11
|
| Nice, thank you...! |
|
|
|
sunitabeck
Flowing Fount of Yak Knowledge
5152 Posts |
Posted - 11/21/2012 : 08:38:31
|
| you are very wlecome.) |
|
|
|
sz1
Constraint Violating Yak Guru
United Kingdom
294 Posts |
Posted - 11/21/2012 : 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
Flowing Fount of Yak Knowledge
5152 Posts |
Posted - 11/21/2012 : 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
Constraint Violating Yak Guru
United Kingdom
294 Posts |
Posted - 01/08/2013 : 07:06:33
|
Thanks again!
SZ1
Learning and development is the driving force in the universe...! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
47173 Posts |
|
|
sz1
Constraint Violating Yak Guru
United Kingdom
294 Posts |
Posted - 01/09/2013 : 02:45:12
|
Thank you!
SZ1
Learning and development is the driving force in the universe...! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
47173 Posts |
Posted - 01/09/2013 : 22:55:37
|
welcome
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
| |
Topic |
|
Sort by Sum Column
