Multiple Date Groupings 1

[ptMarke]

Hey all,

I am trying to do a "yearly comparison" type chart where i have the gross earnings on the Y axis, and the month on the X axis, with a new line for each year. ie

|    **      xxxxxxxxxxxxx
|****  **xxxx             xxxxx....
|    xxxx****
|  xx        ****         *****.....
|xx              *********
|
---------------------------------------------
JAN FEB MAR APR JUN JULY AUG SEP OCT NOV DEC

where * = 2000
      x = 2001

for example..

Im using a cross-tab report, and what i am getting is months in the format

01/2000 02/2000 ............. 12/2001

and the line for 2000 has profits for the first 12 months, then drops to zero for the second 12 months.. and the line for 2001 is zero until the end of the 2000's and then shows profits on the second half of the chart.

I know what i want to do must be possible.... can anyone tell me how??? what am i doing wrong?

Any help appreciated.

Regards,

Mark Allanson
Software Developer
PalmTEQ Limited

 

[kenhamady]

Create a formula called "Month":

Month ({datefield})

Then use that as your column field in the Cross-tab. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/