Hi I have a report (crystal report 10 with vs.net 2005). The data looks like
location date value
calif 2/1/2006 10.5
calif 2/5/2006 12.2
nevada 3/1/2006 5
calif 2/1/2007 2
calif 2/5/2007 4
The data spans a full year as far as the date goes. Is there any way to display 12 charts, one for each month. and The charts compare totals for the same month but a year apart, for each location? The chart for Feb would look like
feb 06/07 comparision
*
* *
* *
calif 06 calif07 nevada06 nevada07
I am not sure if I can do this within the report itself so may need to modify the query.
Thanks
location date value
calif 2/1/2006 10.5
calif 2/5/2006 12.2
nevada 3/1/2006 5
calif 2/1/2007 2
calif 2/5/2007 4
The data spans a full year as far as the date goes. Is there any way to display 12 charts, one for each month. and The charts compare totals for the same month but a year apart, for each location? The chart for Feb would look like
feb 06/07 comparision
*
* *
* *
calif 06 calif07 nevada06 nevada07
I am not sure if I can do this within the report itself so may need to modify the query.
Thanks