Solved

Sort display of one column by value of another

Posted on 2011-03-07
7
676 Views
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
0
Comment
Question by:gberkeley
  • 4
  • 3
7 Comments
 

Author Comment

by:gberkeley
Comment Utility
Here is the RB view of the report definition. SHows filelds to be sorted
0
 
LVL 37

Expert Comment

by:ValentinoV
Comment Utility
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
 
LVL 37

Accepted Solution

by:
ValentinoV earned 500 total points
Comment Utility
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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Closing Comment

by:gberkeley
Comment Utility
Terrific answer - you helped me figure out the missing piece of the puzzle! Thanks!
0
 
LVL 37

Expert Comment

by:ValentinoV
Comment Utility
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
 

Author Comment

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

Expert Comment

by:ValentinoV
Comment Utility
Comment added :-)

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

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
MS SSRS scale out 13 64
sql syntax error 9 72
SQL Upgrade 3 42
SQL Server Communications Audit 5 15
Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

763 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

13 Experts available now in Live!

Get 1:1 Help Now