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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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?
Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.


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

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSRS - Suppress row when blank from 2nd dataset 2 71
Ssrs date parameters 12 146
sql 2012 cluster  SSRS cluster aware 2 29
SSRS String Manipulation 6 49
Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (  This article explained how …
Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

756 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