Report Builder 2.0 and Column Sorting?
In my dataset t-sql query I wanted to omit "ORDER BY" and let the end user do the column sorting in RB. RB does not appear to let them sort columns. Is that correct?
TIA,
Barkgindpg
P.S. I wonder if the same is true for RB 3.0
November 14th, 2010 12:14pm
Hi Barkgindpg,
The answer for your question should be depend.
Yes, in a DataSet in Report Builder, we are unable to sort it without the "ORDER BY" clause. However, we can sort the data if we want to display it in a tablix control.
In the properties of a tablix control, there is an option named "Sorting". In the "Sorting" tab, we can add multiple conditions to sort the rendered data in the report.
For more information about sorting, please see:
Sorting Data in a Report:
http://msdn.microsoft.com/en-us/library/ms157313(v=SQL.100).aspx
If you have any more questions, please feel free to ask.
Thanks,
Jin ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
November 15th, 2010 12:38am