I'm trying to create a report and graph with the following:
For each day I capture the max speed a driver drives. On the report, I group by driver and day. For each day I want to display the number of times a driver exceeded a speed range. I have 5 ranges. 50-60 mph, 60-70 mph, etc.
So for example, the report prints:
Date 50-60 60-70 70-80 80-90
1/2/02 3 1 1 0
1/3/02 2 2 1 1
Total 5 3 2 1
I can then drill down by clicking on a day and see the detail rows that resulted in the category totals. What I'd like to do is display a bar chart for each driver that shows for each day, what the totals for each group were and be able to drill down to the detail for that speed group for the day.
The only chart I've been able to create is a bar chart by driver that displays the grand totals for each category for the driver. I did this by Changing on the Driver Name and showing the values of the Summarized totals that display in the driver group footer. I can't figure how to display multiple bar graphs within 1 bar graph to display in one bar graph separate bar graphs that represent each day and the speed groups for that day.
Can Crystal handle what I am trying to accomplish ?
Thank you
For each day I capture the max speed a driver drives. On the report, I group by driver and day. For each day I want to display the number of times a driver exceeded a speed range. I have 5 ranges. 50-60 mph, 60-70 mph, etc.
So for example, the report prints:
Date 50-60 60-70 70-80 80-90
1/2/02 3 1 1 0
1/3/02 2 2 1 1
Total 5 3 2 1
I can then drill down by clicking on a day and see the detail rows that resulted in the category totals. What I'd like to do is display a bar chart for each driver that shows for each day, what the totals for each group were and be able to drill down to the detail for that speed group for the day.
The only chart I've been able to create is a bar chart by driver that displays the grand totals for each category for the driver. I did this by Changing on the Driver Name and showing the values of the Summarized totals that display in the driver group footer. I can't figure how to display multiple bar graphs within 1 bar graph to display in one bar graph separate bar graphs that represent each day and the speed groups for that day.
Can Crystal handle what I am trying to accomplish ?
Thank you