New to Crystal Reports... I have 2 existing reports, and I want to create a report that calculates a metric, using the results of the 2 reports, linked by the grouping that I used in each.
- Report A from table 1 counts all shipments by date, grouped by month
- Report B from table 2 sums hours of network outage, grouped by month
I want to calculate (sum of hours outage)/(running total of shipments), and display graphically by month
Working with subreports, I have only been able to pass one single value to the main report, not all values by month to do the math
I would imagine this is a pretty simple task, I have done this using other tools, but have not found a simple way in Crystal Reports yet. Any help would be appreciated