Crystal Report Chart with multiple groups

I'm not sure if this is possible or not, but I have a report finished that I would like summarized in a graph.  Its an injury report with types of injury (first aid, lost time, etc.) and whether the injuries were occupational or non-occupational, grouped by department.  So the groups go from Group 1 Department to Group 2 Injury Type to Group 3 Occ/NonOcc.  Ideally, I would like to do a stacking bar graph that would have a bar for each injury type separated in the stack by occupational/non-occupational and then these bars grouped by the department.  The data used is counted in Running Total fields in the group footers as well, so this will have to be considered if this is even possible.  
Any assistance/guidance would be much appreciated.
simpson18Asked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
The running totals cannot be used a graph since they are calculated after the graphs are created.

Are you trying to get 1 graph for all the data or do you want separate graphs for each department.

Have you tried creating a graph for the data?

mlmcc
0
 
simpson18Author Commented:
I would prefer one graph for all of the data.  I can create multiple graphs and get what I need, but its a summary report and when you have six graphs for very similar data, it gets kind of busy for a "summary" and with the other two subreports, it will become a two page report instead of one - something I was hoping to avoid.

Now, just thinking about it, could I make manual running totals variables in formulas and use the variables in a parent report then do a chart in the parent report?  I don't think the chart grouping would work then, though.  And you can't have a subreport within a subreport, either, right?
0
 
mlmccCommented:
You are correct no subreports within a subreport.

Have you tried putting a chart in or must the values be don e in running totals?

mlmcc
0
 
simpson18Author Commented:
I can get it to work to the second group, but it won't allow any additional groups.  It works fine for the first two groups, though.  I think this is the limitation in Crystal.  I've tried different chart types as well, and it simply won't let me put a third "on change of" into the chart.  However, this may be sufficient after discussing it with management.  The third level of detail can be in a numeric summary separately prepared as it is only needed once per month, while this chart will be reviewed weekly.  You've pretty much answered my questions, so I'll give you the points.  Thanks for your help.  
0
 
mlmccCommented:
I believe you are correct about the 2 on change of.

I don't use charts that often and generally they are fairly simple to do.

mlmcc
0
All Courses

From novice to tech pro — start learning today.