Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

RDLC Report is not sorted the way I tell it to

Tags:

sorting

xsd

rdlc

I've got an RDLC report that looks great, but strangely the data is not sorted the way I specified in the XSD file that I'm using as a DataSource. When I "Preview Data" in the XSD file, it is sorted correctly.

I can't find any setting that would be overwriting the sort order of the data in either my calling ASP file or the RDLC file and am stumped. I may try manually sorting the data, but it seems like it shouldn't be this difficult.

Thanks for any pointers you have.

like image 580
SaltyDog Avatar asked Sep 07 '11 15:09

SaltyDog


People also ask

How do I add a DataSet to an existing Rdlc report?

To create a dataset for the RDLC report, click Reporting under Visual C# Items. Click Report, and then click Add. The Report Wizard opens. Enter a dataset name in Name field.To choose a data source for the dataset, click New on the right of Data source drop-down combo box.

How do I change the DataSet name in Rdlc?

In visual studio if you have the RDLC open you can open the Report Data window by pressing CTRL + ALT + D . From here you click on datasets and then right click on the data set to refresh it. Show activity on this post. Right Click on Required Stored Procedure .


2 Answers

It has been a while, but the report also has a sort option somewhere. You may want to be sure that matches.

like image 130
Mike Wills Avatar answered Sep 17 '22 18:09

Mike Wills


This is old, but I found that in the report designer there's multiple places to check the sorting configuration.

Tablix Properties and Group Properties both have sorting options which may be conflicting.

enter image description here

like image 39
Ben Winding Avatar answered Sep 17 '22 18:09

Ben Winding