SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Sort by Sum Column
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sz1
Constraint Violating Yak Guru

United Kingdom
457 Posts

Posted - 11/21/2012 :  04:40:51  Show Profile  Reply with Quote
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

5155 Posts

Posted - 11/21/2012 :  06:49:17  Show Profile  Reply with Quote
Don't sort on the tablix level. Sort on the group. Right-click the group, Group Properties -> Sorting tab.
Go to Top of Page

sz1
Constraint Violating Yak Guru

United Kingdom
457 Posts

Posted - 11/21/2012 :  06:56:34  Show Profile  Reply with Quote
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)
Go to Top of Page

sunitabeck
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 11/21/2012 :  07:35:48  Show Profile  Reply with Quote
Row Groups -> right click the group, -> Group Properties -> Sorting tab -> Add -> click expression button, -> select Datasets in category -> select Count(Call_ID) -> OK.
Go to Top of Page

sz1
Constraint Violating Yak Guru

United Kingdom
457 Posts

Posted - 11/21/2012 :  07:47:11  Show Profile  Reply with Quote
Nice, thank you...!
Go to Top of Page

sunitabeck
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 11/21/2012 :  08:38:31  Show Profile  Reply with Quote
you are very wlecome.)
Go to Top of Page

sz1
Constraint Violating Yak Guru

United Kingdom
457 Posts

Posted - 11/21/2012 :  10:02:28  Show Profile  Reply with Quote
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
Go to Top of Page

sunitabeck
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 11/21/2012 :  11:51:17  Show Profile  Reply with Quote
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.
Go to Top of Page

sz1
Constraint Violating Yak Guru

United Kingdom
457 Posts

Posted - 01/08/2013 :  07:06:33  Show Profile  Reply with Quote
Thanks again!

SZ1
Learning and development is the driving force in the universe...!
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 01/09/2013 :  00:06:48  Show Profile  Reply with Quote
http://sqlserverpedia.com/blog/sql-server-bloggers/visibility-settings-in-ssrs-drill-down-to-showhide-report-data/

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

sz1
Constraint Violating Yak Guru

United Kingdom
457 Posts

Posted - 01/09/2013 :  02:45:12  Show Profile  Reply with Quote
Thank you!

SZ1
Learning and development is the driving force in the universe...!
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 01/09/2013 :  22:55:37  Show Profile  Reply with Quote
welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000