SSRS 2008R2 Ent. Report Builder 3. Sorting not working
Hi, I'm currently doing a Proof of Concept / Gap analysis with the above stack for a move from Cognos. We cannot seem to get Sorting working. Even on a simple 5 line table from a sql table. Let alone SSAS queries. I have tried interactive sorting, tablix sorting, dataset sorting (order by). Nothing works. Data is always sorted by the first column, regardless. This also occurs with MDX queries. Is sorting broken in SSRS? If so, can we get that confirmed as it will rule SSRS out for our site.
January 27th, 2011 5:25am

Hi LittleRascal, ReportBuider 3.0 supports interactive sorting, tablix sorting, dataset sorting (order by). If you add several sorting datafields to the tablix, the table will sort the tablix by the first datafield in the first place, then the second datafild, I think you might give several sorting datafields to the tablix. But you could add interactive sorting to all the columns of tablix. For more information see below: How to: Sort Data in a Data Region (Report Builder 3.0 and SSRS): http://msdn.microsoft.com/en-us/library/dd255193.aspx Interactive Sorting (Report Builder 3.0 and SSRS) http://msdn.microsoft.com/en-us/library/dd207011(SQL.105).aspx If I misunderstand you, please feel free to let me know. Thanks, Challen Fu Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
January 31st, 2011 1:52am

Can you please give data which you want to sort any way if data sorting graph it need to be sort in expression like this http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/569f22aa-b4c0-4b3c-9c62-a3f1f637508b/#037dc38e-1787-4b24-a731-522a71a3e6d6 or if there is shift work and shift run on day and night basis then like this. =IIf(Fields!Shift.Value ="D",Switch(Fields!Hours.Value = 6, 1, Fields!Hours.Value = 7, 2,Fields!Hours.Value = 8, 3, Fields!Hours.Value = 9, 4, Fields!Hours.Value = 10, 5, Fields!Hours.Value = 11, 6, Fields!Hours.Value = 12, 7, Fields!Hours.Value = 13, 8, Fields!Hours.Value = 14, 9, Fields!Hours.Value = 15, 10, Fields!Hours.Value = 16, 11, Fields!Hours.Value = 17, 12, Fields!Hours.Value = 18, 13),Switch(Fields!Hours.Value = 18, 1,Fields!Hours.Value = 19, 2, Fields!Hours.Value = 20, 3,Fields!Hours.Value = 21, 4, Fields!Hours.Value = 22, 5, Fields!Hours.Value = 23, 6, Fields!Hours.Value = 24, 7, Fields!Hours.Value = 0, 8, Fields!Hours.Value = 1, 9, Fields!Hours.Value = 2, 10, Fields!Hours.Value = 3, 11, Fields!Hours.Value = 4, 12, Fields!Hours.Value = 5,13, Fields!Hours.Value = 6, 14) ) this kind of sorting u can you use for sorting any kind of data in graph...... Ericcsico
February 1st, 2011 11:17am

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

Other recent topics Other recent topics