Hello epicor community, need you help on this customize ssrs for stock status report, I’m trying to sort the report by part description but to no avail, can refer image below.
Whenever I try to generate it does not sort by alphabetical order, I tried duplicate the rdd but still cant sort, need your help on this.
If you customized the SSRS report, that may be where your problem is. It’s actually the SSRS that does the sort. The parameters that you select on the report creates a “sort key”, so if you are sorting by Warehouse/Part, the sort key is the Warehouse concatenated with the Part Number. If you sort by Part/Warehouse, the sort key is the Part Number concatenated with the Warehouse, and so on.
If you want to debug it, go to the details section of your tablix, go into the group properties for the detail section, and look at sorting. That’s what it’s being sorted on. To troubleshoot, you might want to add that field directly to the report temporarily to see the values in it.
It’s not uncommon in a custom SSRS report that’s copied from a standard report that much of the logic inside is modified to a specific requirement, sometimes rendering the selection criteria that is used on the standard report meaningless in the custom report. Or to put another way, sorting can be hardcoded in a custom report because someone removed the logic that allowed multiple sorts.
