I have a report that is reporting 4 variables per month. Each Month has different values. The database structure is:
Month:Data1:Data2:Data3:Data4
Month:Data1:Data2:Data3:Data4
.....
I would like to format the report such that I have 1 year of data horizontally as in:
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Data1 Data1 Data1 Data1 Data1 Data1 Data1 Data1 Data1 Data1 Data1 Data1
Data2 Data2 Data2 Data2 Data2 Data2 Data2 Data1 Data2 Data2 Data2 Data2
Data3 Data3 Data3 Data3 Data3 Data3 Data3 Data1 Data3 Data3 Data3 Data3
Data4 Data4 Data4 Data4 Data4 Data4 Data4 Data1 Data4 Data4 Data4 Data4
I have tried inserting a cross tab report but I can not seem to make it format as above.
Any help would be appreciated.