Forum Discussion
Help with grouping values in matrix
I am building a Paginated Report where information must be filtered by the company name, the issue is:
I need to group the rows by date (format MMMM YYYY)and the columns have to be in a specific order, the way they are being displayed now is by alphabetical order.
This is how the matrix is created:
Any help will be appreciated as I've working on this for days and want to get it over with. Thanks!
1 Reply
To fix this you would need to add a sort by column to your date table. I usually use something like YYYYMM as an integer for sorting months. Then add this column to your query and either add an ORDER BY to your query (which is usually more efficient as it will do the sorting at the data source) or set the sorting on the dataset in Report Builder
