October 16, 2014 at 12:12 pm
Hello everybody,
I am trying to create a calendar style report will have 12 months (as columns) and store opening listing in rows. I have created a matrix, but the problem that I have that the store opening listings display in the right period, but they are not in any order. I would like to have the openings always on top, right under the header in the matrix. Now I have them scattered randomly all over the matrix. I tried numerous way of sorting and that does not help.
I am attaching a sample of what I would like to accomplish (months are columns).
thanks for any and all help,
Petr
October 30, 2014 at 6:39 pm
vecerda (10/16/2014)
Hello everybody,I am trying to create a calendar style report will have 12 months (as columns) and store opening listing in rows. I have created a matrix, but the problem that I have that the store opening listings display in the right period, but they are not in any order. I would like to have the openings always on top, right under the header in the matrix. Now I have them scattered randomly all over the matrix. I tried numerous way of sorting and that does not help.
I am attaching a sample of what I would like to accomplish (months are columns).
thanks for any and all help,
Petr
In your query that is getting you the dataset, sort by opening date. Then group in the matrix by month. If you can't sort at the query stage, then in your tablix, you can sort by opening date. If you don't have an opening date, then sort on whatever it is that identifies a store as "opening". To get a better answer, you have to provide better info, i.e. what does your data actually look like?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply