Skip to Content
0
Former Member
Apr 16, 2010 at 01:29 PM

Crystal reports VS 2008 Horizontal reporting

26 Views

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.