July 23, 2007 at 4:27 pm
Hello! I have a matrix report that has the months across the top. I've tried to control the sorting in my stored procedure but that didn't work. Does anyone know how to sort on the column? I'm assuming (since I couldn't find anything) that I'll need to do that as an expression. If someone has the syntax for that, I'd really appreciate it!! Thanks! Jamie
July 24, 2007 at 4:21 am
I am assuming that it is the months across the top of the matrix you need to sort on. I am also assuming that you have a column in the dataset containing the month number, this will also work even if you display months by name.
(1) Right click on the matrix and select properties.
(2) Click the Groups tab.
(3) In the columns list box, select the group that groups by months (this can be a guessing game if you haven't named the groups appropriately). Then click Edit...
(4) Check the expression is the right on for months (if not cancel and try another group). Then Click the Sorting tab.
(5) Add and expression for the month numbers which should be as simple as selecting a field from the recordset.
(6) Click Ok and Ok again.
That should be it.
I tend to have my dataset with the month number only then use the MonthName function to return the name in the value expression for the cell.
July 24, 2007 at 7:39 am
Thank you so much! I did have the month number. Just wasn't going about it the right way. Thanks again!! Jamie
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply