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 ...
d_gosbell
Super User
Super UserTo 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