I have the following sample to illustrate what I have done and doing nothing to sort the list after making changes when I go to Group Properties>Sorting> Add> Sort by PerformedForPersonID from A to Z.
Note: The field I want to sort are (int, null)> Anyway, this is the cause of it since the sorting only has it from A to Z, or does this apply to just only to strings character like letters and numbers and not int?
That is the only way I sort things here. Any ideas as to how I can sort the following sample?:
Thanks for the post, but I really want to do it using the Report Viewer SSRS 2208 R2. I appreciate it. If I was to create the table that way and have it descending for field, how would I do this? Because I added the ORDER BY clause and it returrned some
error. I guess because I am joining another table within this view.
elvinPena
Member
38 Points
89 Posts
Sorting a column
Feb 27, 2013 02:30 PM|LINK
I have the following sample to illustrate what I have done and doing nothing to sort the list after making changes when I go to Group Properties>Sorting> Add> Sort by PerformedForPersonID from A to Z.
Note: The field I want to sort are (int, null)> Anyway, this is the cause of it since the sorting only has it from A to Z, or does this apply to just only to strings character like letters and numbers and not int?
That is the only way I sort things here. Any ideas as to how I can sort the following sample?:
Sample:
PerformedForPerson
------------------------
2
35
66
1999
I want it as:
PerfomredForPerson
----------------------------
1999
66
35
2
<div></div>Rion William...
All-Star
32214 Points
5234 Posts
Re: Sorting a column
Feb 27, 2013 02:57 PM|LINK
You just need to use ORDER BY (Property) DESC within your SQL call :
SELECT * FROM PerformedForPersonTable ORDER BY PerformedForPerson DESCExample
elvinPena
Member
38 Points
89 Posts
Re: Sorting a column
Feb 27, 2013 03:12 PM|LINK
Thanks for the post, but I really want to do it using the Report Viewer SSRS 2208 R2. I appreciate it. If I was to create the table that way and have it descending for field, how would I do this? Because I added the ORDER BY clause and it returrned some error. I guess because I am joining another table within this view.
Abhi.ssrs
Member
262 Points
52 Posts
Re: Sorting a column
Mar 01, 2013 06:26 AM|LINK
Hi Elvin!
The Sort order A-Z and Z-A is only indicative and applies to both Numeric and string values. You may try using Z-A sort for your desired output.
You can implement this sort at the Tablix level or at the group level
Please let me know in case it doesn't work and I will post alternative solution.
Thanks,
Abhinav