Sales by Month Bar Chart - Last 12 Months 2

[mwake]

I'm using Crystal Reports 2008 and the data source is an Oracle db. I want to create a sales by month bar chart that captures the current month's sales and the previous 11 months. IS there any way to get the chart to roll over automatically when the month changes?? The only thing I can think of is to create a formula for each month that extracts the current month from the current date, then subtracts months to get prior month numbers. Any ideas on how to make this work??

 

[lbass]

I would use dateserial(), as in:

//{@month}:
if {table.date} in dateserial(year(currentdate),month(currentdate),1) to currentdate then
totext(dateserial(year(currentdate),month(currentdate),1),"MMMM yyyy") else //this month
if {table.date} in dateserial(year(currentdate),month(currentdate)-1,1) to dateserial(year(currentdate),month(currentdate),1)-1 then
totext(dateserial(year(currentdate),month(currentdate)-1,1),"MMMM yyyy") else //last month
if {table.date} in dateserial(year(currentdate),month(currentdate)-2,1) to
dateserial(year(currentdate),month(currentdate)-1,1)-1 then
totext(dateserial(year(currentdate),month(currentdate)-2,1),"MMMM yyyy") else //two months ago
//etc.

You can use this as your on change of field in the chart.

-LB

 

[mwake]

Thanks LB. That worked perfectly!!