I wrote two formulas to organize the columns of a cross tab report buy quarter and month (Crystal 8.5).
Month:
if {CONTHIST.ONDATE} in Date (2003, 01, 01) to Date (2003, 01, 31) then 'Jan' else
if {CONTHIST.ONDATE} in Date (2003, 02, 01) to Date (2003, 02, 28) then 'Feb' else
if {CONTHIST.ONDATE} in Date (2003, 03, 01) to Date (2003, 03, 31) then 'March' etc.
Quarter:
if {@On Date} like 'jan'then 'Q1'else
if {@On Date} like 'feb'then 'Q1'else
if {@On Date} like 'march'then 'Q1' else
if {@On Date} like 'april'then 'Q2'else
if {@On Date} like 'may'then 'Q2'else
if {@On Date} like 'june'then 'Q2' etc.
When I run the report, the months are out of order. How do I get the report to run Jan, Feb, March, etc.
Thanks
Month:
if {CONTHIST.ONDATE} in Date (2003, 01, 01) to Date (2003, 01, 31) then 'Jan' else
if {CONTHIST.ONDATE} in Date (2003, 02, 01) to Date (2003, 02, 28) then 'Feb' else
if {CONTHIST.ONDATE} in Date (2003, 03, 01) to Date (2003, 03, 31) then 'March' etc.
Quarter:
if {@On Date} like 'jan'then 'Q1'else
if {@On Date} like 'feb'then 'Q1'else
if {@On Date} like 'march'then 'Q1' else
if {@On Date} like 'april'then 'Q2'else
if {@On Date} like 'may'then 'Q2'else
if {@On Date} like 'june'then 'Q2' etc.
When I run the report, the months are out of order. How do I get the report to run Jan, Feb, March, etc.
Thanks