Sort display of one column by value of another

Posted on 2011-03-07
Last Modified: 2012-05-11
I have a very simple query that generates a list of agency names. I want to sort this list in alpha order showing first all those where external=true then those where external=false.

Can't seem to get a group expression to do it. Changed the .rsd and sorted there, didn't matter on the report side.

How do I get the list to show me the "falses" first?  RB view of .rdl
Question by:gberkeley
  • 4
  • 3

Author Comment

ID: 35059172
Here is the RB view of the report definition. SHows filelds to be sorted
LVL 37

Expert Comment

ID: 35066657
Right-click the grey border of the table (in design view) and select Tablix Properties.  Then select the Sorting page.  In that page you should add two lines: the first one to sort on your External field, the second to sort on Agency.  That should result in your data being ordered first on External, then Agency.
LVL 37

Accepted Solution

ValentinoV earned 500 total points
ID: 35066753
My comment above was assuming that you're using a table, not a matrix.  Looking at your screenshot, it seems like you're using a matrix so you'll need to set up the sorting differently.

To get your "falses" in the first lines followed by the "trues", you should open the Group Properties by clicking the dropdown arrow for your Agency Row Group (below the report design there are two boxes called Row Groups and Column Groups.  In Row Groups there should be an item, open the properties of that item).

Then select the Sorting page and add your External field as first one to group on.  Agency will probably already be in the list.  After adding External, you can use the button with the up arrow to get it to first sort on External.

Hope that helps?
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.


Author Closing Comment

ID: 35068791
Terrific answer - you helped me figure out the missing piece of the puzzle! Thanks!
LVL 37

Expert Comment

ID: 35072466
Glad I could help you out!  Thank you for getting me one step closer to the 500.000 points as required to become a Sage :-)

Author Comment

ID: 35183023
Valentino - I have a new question out there - please would you take a look? (Better yet, follow me!) I really appreciate your help.
LVL 37

Expert Comment

ID: 35187130
Comment added :-)

(I can follow you if you like, but I never look at that, so it wouldn't make a difference...)

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Sending a Secure fax is easy with eFax Corporate ( First, just open a new email message. In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now