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?
Hi, Are you connecting to the correct database? I know it sounds like a really dumb thing to say, but its happened to me. I make the data source to look at our test system and create the report, make changes to the SP and stuff, then forget to repoint the data source to the live database.
Please ignore me if I'm talking rubbish.
Debbie