I am using Crystal Report Designer Component 8 and my database is in Oracle.i wish to design a cross tab report as given below. i am trying to design cross-tab report as under …… but not getting the
required result……this report is about the planned sales of a product against achieved sales of that perticular product…..on monthly basis… showing prod.name and sales(both planned and achieved) in coloums and months in rows.
Unit No1
Prod1 Prod2
Pl_sale Achi_sale Pl_sale Achi_sale
Jan00 40.00 30.00 50.00 40.00
feb00 40.00 35.00 60.00 55.00
Total 80.00 65.00 110.00 95.00
can i design cross tab report of this kind if yes…… then how can i design the tabs of a crostab report in the above required manner soas to get such a report.(Please Bear with the report format above as this text only editor does not support formating of text.)
thank you
Amol Nagraj