Date formula for crosstab column header 1

[HollyS]

In Crystal 10, I'm trying to write a cross-tab that will show quantities sold for help in production. They want to see same month last year's plus the next three months of PY to help them forecast what to produce this year.

I'm having trouble with the date formula for my column header. The report should look like:

Oct-09 Nov-09 Dec-09 Jan-09 Total
Item 1
Item 2
Item 3
etc.

Thank you.

 

[lbass]

Use a record selection formula like this:

{table.date} in dateserial(year(currentdate)-1,month(currentdate),1) to
dateserial(year(currentdate)-1,month(currentdate)+4,1)-1

Then in your crosstab, choose {table.date} as your column field->options->print on change of month.

-LB

 

[HollyS]

Spot on! Thanks!