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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics