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