This is a migrated thread and some comments may be shown as answers.

crosstab table doesn't keep sort order

1 Answer 111 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Kris
Top achievements
Rank 1
Kris asked on 18 Sep 2012, 08:31 PM
I have a crosstab table that I am binding to "Samples". Each sample has a date, I order these coming out of sql from oldest to newest (ie 01/01/11 comes before 02/01/11).

I have verified my IEnumerable is ordered correctly, as shown by the attached screenshots (photo1 & photo2). But when the report is generated, it does not order it correctly (photo3 & photo4). It also ignores the order of a DataTable (photo5)

Why is it ignoring the order of my datasource? Any ideas?

Thanks

1 Answer, 1 is accepted

Sort by
0
IvanY
Telerik team
answered on 21 Sep 2012, 04:25 PM
Hello Kris,

It is absolutely normal your dates to not be ordered in your crosstab, as currently your data is ordered by SampleID (the first row) and by Lab Sample ID. If you want to apply different sorting you will have to choose both groups and sort them by date.

I hope that helps.

Kind regards,
IvanY
the Telerik team

BLOGGERS WANTED! Write a review about Telerik Reporting or the new Report Designer, post it on your blog and get a complimentary license for Telerik Reporting. We’ll even promote your blog and help bring you a few fresh readers. Yes, it’s that simple. And it’s free. Get started today >

Tags
General Discussions
Asked by
Kris
Top achievements
Rank 1
Answers by
IvanY
Telerik team
Share this question
or