Sort display of one column by value of another

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
gberkeleyAsked:
Who is Participating?
 
ValentinoVConnect With a Mentor BI ConsultantCommented:
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?
0
 
gberkeleyAuthor Commented:
Here is the RB view of the report definition. SHows filelds to be sorted
0
 
ValentinoVBI ConsultantCommented:
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.
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
gberkeleyAuthor Commented:
Terrific answer - you helped me figure out the missing piece of the puzzle! Thanks!
0
 
ValentinoVBI ConsultantCommented:
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 :-)
0
 
gberkeleyAuthor Commented:
Valentino - I have a new question out there - please would you take a look? (Better yet, follow me!) I really appreciate your help.
0
 
ValentinoVBI ConsultantCommented:
Comment added :-)

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

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.