Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Sort display of one column by value of another

Posted on 2011-03-07
7
Medium Priority
?
733 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
ID: 35059172
Here is the RB view of the report definition. SHows filelds to be sorted
0
 
LVL 37

Expert Comment

by:ValentinoV
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.
0
 
LVL 37

Accepted Solution

by:
ValentinoV earned 2000 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?
0
[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

 

Author Closing Comment

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

Expert Comment

by:ValentinoV
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 :-)
0
 

Author Comment

by:gberkeley
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.
0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 35187130
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

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

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

Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses

569 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