SSRS Report Sorting

Try this, on the menu of Visual Studio while you have the .rdl loaded, go to “View” Select “Code” and do an search for “sort”. This may help you find where the sorting is occurring. I had issues in the past where I add something, usually parameters, and then removed them but they were still referenced in the code.

My brain for some reason isn't functioning today.

I have an SSRS report with a table. The table contains one group. The group is set to sort on name rather than customer_no or order_no or any of the other lovely columns in it. I preview the report. It's sorting on order_no. I check the group sorting, definitely has no mention of order_no. I check the table sorting. It's identical the the group's sorting, set to sort on name, no mention of order_no anywhere. I even altered the SP so it is sorting on name too. I tried flipping the column order in the stored procedure AND the table, just to see if it were for some reason sorting by the first column despite being set to do otherwise. No difference. Still it sorts on order_no. I've created dozens of SSRS reports with tables before. They all sort the way I tell them to. On the sorting tab. In the report.

What am I missing?

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!