Skip to Content
0
Former Member
Apr 28, 2009 at 02:03 AM

Chart

37 Views

Hi,

I am using Crystal Reports 2008, with SQL Server 2000.

My database has the data like the following

Date Item

01/02/09 pen

05/02/09 disk

05/02/09 pen

10/02/09 pen

05/03/09 disk

05/03/09 pen

15/03/09 disk

and so on....

I need to provide a stacked bar chart summarizing this data per month, like:

Month Item qty

Feb pen 3

Feb disk 1

Mar pen 1

Mar disk 2

showing the last 12 months(having or not data on it).

can anyone help me on it?

Thanks