Crystal Reports Percent Bar Chart
Posted on 2005-02-28
I have a problem with a percent bar chart in the report i am currently working on.
To give some background:
The Report is being developed in Crystal Reports V.9.
The report is to calculate how many visits to patients a staff member makes and what proportion of these calls are the different reasons for care.
The report has three groups: StaffName, Date_Of_visit (grouped by month) and Reason_For_Care (4 categories : Diabetes, Leg_Ulcer, Foot_Ulcer and All_Other_Reasons)
I have the chart set up to be displayed in the footer of each staffName group (in the case of the current report there will be 2 members of staff hence two charts)
The Chart that i have created seems to give the correct values but the output is where the problem is. The legend for the chart is in a different order for each member of staff in the report. This means that the percentage sections in the bar chart are not ordered uniformly for each chart.
Is there a way to alter the order of the legend so that it is the same format for each chart. As it is at the moment, comparing similar reasons_for_care is very awkward between differnet charts.
Hopefully this makes sense, any help is much appreciated.
Thanks in advance.