SSRS Matrix Report: How to sort column based on sequence number
One of my columns for the matrix report is taskcode. Right now it sorts the taskcode's alphabetically. I created a table and assigned a sequence to each of the taskcodes that I am reporting on and want to sort based on that sequence instead of having it sort them alphabetically. I tried adding the sequence table to the view and I can sort successfully inside of the query but on the report itself it seems to ignore that logic. Any feedback on how to accomplish this would be greatly appreciated.