Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Mar 01, 2013 06:26 AM by Abhi.ssrs
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?:
I want it as:
Feb 27, 2013 02:57 PM|LINK
You just need to use ORDER BY (Property) DESC within your SQL call :
ORDER BY PerformedForPerson DESC
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.
Mar 01, 2013 06:26 AM|LINK
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.