crystal reports chart

[balllian]

Can anyone help. I'm attempting to create a chart which goes jan>dec for the last couple of years grouped by subcategory. The report will compare the value of each subcategory by month ie compare jan 04, jan 05, jan 06 etc against each other.

How would i produce such a report. The month data is currently stored as dd/mm/yyyy.

Thanks in advance for any assistance

Ian

PS Im using version 8.5

 

[lbass]

Is your date field a string or a date datatype?

-LB

 

[balllian]

its stored in an access database as date/time field

 

[lbass]

I think you would have to do a chart per subcategory. Insert a group on subcategory, and then create two formulas:

//{@mo}:
month({table.date})

//{@year}:
year({table.date})

Add {@mo} as your first on change of field, and {@year} as the second. If you want to display the abbreviated monthname instead of the monthnumber, use:

monthname(month({table.date}),true)

Then click on "order" and choose specified order in order to order the months.

-LB