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.
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.
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 .
It has been a while, but the report also has a sort option somewhere. You may want to be sure that matches.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With