sql_novice_2007 (9/27/2013)
Hi,I was able to implement this with pivot and matrix report. I have all the row groups in the beginning and column groups in the end in the report. But I need couple of row groups to be at the end of the report. I changed that order in the data set but it's not showing up in the report. Is there a way I can drag them to the end.
I have report headers like the following.
country,State,city,total,avg,jan2012,feb2012,mar2012,apr2012,may2012...dec2012.
in the above headers jan2012 to dec2012 comes from column group and the others from row group.
Now I want the display to be like the following
country,State,city,jan2012,feb2012,mar2012,apr2012,may2012...dec2012,avg,total
How can I do this?
Thanks.
To do this, you will need to explicitly handle the order of the columns in the report - the group column group in the matrix has a field to order the heading. Add an expression to this field that puts the columns in the order you are after. Personally, I include a column in my data source that deals with this (i.e. I have a column for the label and a separate column for the column order in the dataset).