Formatting cross tab report 1

[BusMgr]

I regularly program Access and VBA, I understand how to do this in that.

I have a cross tab report of company versus monthly sales. Company is the row, month is the column. My underlying data is in a table that I am using bTrieve SQL to pull out of Peachtree. Peachtree's date format is yyyy-mm-dd.

I created a simple formula to pull the month from the date in Crystal. Month({TransactionalDate}), which gives the date in numeric format, ie 1,2,3. How can I format it to Jan, Feb, Mar, etc.

I am a complete newb to Crystal, but I am learning fast. It is Crystal 8.5.

Thanks for your help in advance.

BusMgr

 

[lbass]

Instead of using the month formula, use the date field itself as the column field. While in the crosstab expert, highlight the column {table.date}->group options and choose "Print for each month". Then in preview you can right click on the column label->format field and choose the month display that you desire.

-LB

 

[tpoettker]

I don't see the group option "print for each month". I can only select ascending or descending. What am I missing?

Tina Poettker

 

[lbass]

Your field is probably not a date datatype. Try converting it to a date first.

-LB

 

[tpoettker]

Thank You. I feel like an idiot!! :0