Skip to Content
0
Former Member
Jan 07, 2011 at 09:14 PM

Crosstab - Quarterly Date Range Column - Need to Print 1st Qtr, 2nd Qtr,etc

292 Views

I am using Crystal 2008.

I have a column in a cross tab that pulls from a date field. In the crosstab expert, in the group options for the column, I have indicated to sort in a specific order, by quarter. In the specified order tab, I have created the orders for 1st Qtr, 2nd Qtr, 3rd Qtr, and 4th Qtr.

However, the colum heatding prints with the the dates of 01/2010, 04/2010, 07/2010, and 10/2010 instead of 1st Qtr, 2nd Qtr, 3rd Qtr and 4th Qtr.

Any suggestions would be appreciated.