I am trying to pull statistics out of a SQL-based Work Order tracking system. For each work order in the system, I track such things as Date Submitted, Requested Competion Date, Committed Completion Date, and Actual Completion Date, along with other header information and detail tables.
I would like to report monthly turns as a ratio: i.e June 2004: 100 work orders submitted, 90 Work orders closed, hence a 90% ratio.
I am struggling with getting to this calculation. I need to create 2 simultaneous groupings: Date Submitted by month, and Actual Completion Date, by month. I can only seem to get these hierarchically, but I want to calculate them in parallel. Can this be done in CR, or do I need to build a query to create this data, then use the query as my source in CR? An example would be quite helpful.
A quick response would be appreciated.