Sorting not working in Crosstab

[Sivam]

Hi,

   Sorting not working in the crosstab. I've given order by in the query. Even i set the Sorting property in crosstab. Sorting is not working. Is it a bug or i need to specify somewhere else? Pls help.

Thanks in advance.

[Steve]

Hi Sivam,

The Table/Crosstab report item has a Sorting property which allows you to specify any expression as a sorting criteria. In this regard sorting the Table/Crosstab by a dynamically chosen column is simply a matter of specifying a proper sorting expression. For example, you can use the IIf() built-in function to decide by which column to sort according to the value of a report parameter. Since I am not familiar with your specific scenario I cannot give you an exact solution. If you're still having problems, please elaborate and we would gladly advise you.
Additionally, you can review the following forum thread for more information and sample reports showing the functionality at hand.

Greetings,
Steve
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Sivam]

Hi, Thanks for the response. Pls find the screenshot of my report attached. I've already specified the Sorting property of the crosstab (OrderBy is a field holding integer value). But while viewing the report, it is sorted based on Title. Any clues?

[Sivam]

I found the solution. Need to specify the sorting option in Group properties.

[Teemee]

Hello, can you tell me how? I have also encountered the same problem.

[Sivam]

Hi Teemee,

Sorry for replying too late. I was busy with my work.
You can right click the row group textbox on you crosstab. Select Row Group -> Group Properties. There you can find the property Sorting. You specify according to your requirement and save.

Pls find attached screenshot for easy understanding.


Thanks,
Siva

[Teemee]

Got it! Thank you SIvam! Big Help!

[Michael]

Hi,

I've got crosstab sorting as per this tread, but only on one column.  I'm trying to sort my column output based on two other columns which are not output - the output is a concatenation of the two columns.  The columns are a number and a letter e.g. 1 and A, 1 and B, 1 and C etc.  So the output values are 1A, 1B, 1C etc.  I can sort on the number part, but if I try to sort on the number and then the letter, it ignores the letter.

Is this a bug?  Should I be able to sort on more than one column in this scenario?  I am using Q3 2010 by the way.

Thanks

[Peter]

Hi Michael,

We have made some tests locally with Q3 2010 and Crosstab item with multiple sorting expressions. In our local tests sorting with number and letter expressions is sorted correctly. Thus if you still experience the problematic behavior we will appreciate if you open a support thread and send us a sample runnable project to debug on our end.

All the best,
Peter
the Telerik team

[Ravi]

Thank you Sivam for posting your solution ....It was big help to me as well ..Thank you

[Sandeep]

This is really helpful SHIVAM.
There are mentioned solutions to set Group Properties. But not bale to see any Group on Report Explorer.

Thanks for your screenshot.

[Rich]

Glad I found this. Just saved me an uncomfortable situation.