Hi All,
I am hoping to create the following report
MAR APR MAY
---- ---- ----
Day CYC Day CYC Day CYC
--- --- --- --- --- ---
MON
TUE 01 02
WED 02 03
THU 03 03 01 04
FRI 04 05 02 04
SAT 01 02 05 06 03 04
SUN 02 04 06 07 04 06
MON 03 07 07 08 05 07
TUE 04 07 08 08 06 07
WED 05 07 09 10 07
THU 06 09 10 12 09
FRI 07 09 11 12 10
SAT 08 10 12 13 11
SUN 09 09 13 15 12
. . . . . .
. . . .
The source table consists of two cols.
Calendar_date DATE
CYC_DAY VARCHAR(3).
Now I need to create a report for a given date range (YYYYMM) and hoping to create the following report as above. Note the group headers should be live (I think) depending on the Range given. For instance if the From Date is 200303 then the report will start from Mar etc. Every day of the entire month is reported against. There are no sums and no aggregation just pretty much retrieve from the table and populate accordingly.
I'm just not too sure how to create this, especially when the Day column (MON - SAT) seems to be static and Day of the month will have to be aligned to its correct day....
Is this sort of reporting possible???
Should I perhaps redesign my source table to allow the above reporting???
Any help or comments will be appreciated...
Kind Rgds.
I am hoping to create the following report
MAR APR MAY
---- ---- ----
Day CYC Day CYC Day CYC
--- --- --- --- --- ---
MON
TUE 01 02
WED 02 03
THU 03 03 01 04
FRI 04 05 02 04
SAT 01 02 05 06 03 04
SUN 02 04 06 07 04 06
MON 03 07 07 08 05 07
TUE 04 07 08 08 06 07
WED 05 07 09 10 07
THU 06 09 10 12 09
FRI 07 09 11 12 10
SAT 08 10 12 13 11
SUN 09 09 13 15 12
. . . . . .
. . . .
The source table consists of two cols.
Calendar_date DATE
CYC_DAY VARCHAR(3).
Now I need to create a report for a given date range (YYYYMM) and hoping to create the following report as above. Note the group headers should be live (I think) depending on the Range given. For instance if the From Date is 200303 then the report will start from Mar etc. Every day of the entire month is reported against. There are no sums and no aggregation just pretty much retrieve from the table and populate accordingly.
I'm just not too sure how to create this, especially when the Day column (MON - SAT) seems to be static and Day of the month will have to be aligned to its correct day....
Is this sort of reporting possible???
Should I perhaps redesign my source table to allow the above reporting???
Any help or comments will be appreciated...
Kind Rgds.