Shared Variable Problem

[mwake]

I'm using CR v10 to create a Warehouse production report. It will contain a date parameter to look at multiple days and then summarize the data at the end of the report. It contains both order and item data. Here is a sample:

Charge Date 11/12/2004

Total orders- 1000
Orders per labor hour- 100
Express Orders- 75
Normal Orders- 925

Total Items 11000
Items per Labor Hour 1100
Express Items 2000
Normal Items 9000

Total Dollars 25000

Average Order Time 42hrs
Standard Deviation 7hrs
Average Order Time Stage 1
etc.....

Charge Date 11/13/2004
Same Data

Charge Date 11/14/2004
Same Data

Summary
Same categories summing all the days.

I first tried to complete this report without a subreport, linking the order header table and order line table by order number. The problem with that was it screwed up my averages and standard deviations for orders because of multiple line items per order. I then created a main report called order and an Item subreport and used shared variables to pass the item info to the main report. That worked with the summary info, but not the daily data. Both reports are grouped by date, and when I pass my daily item count to the main report, I get a total item count appearing in each day rather than the individual totals appearing on the proper days. Is there a way to make this work??

 

[lbass]

The subreport should be placed in the group (date) header (or footer), and the subreport should be linked to the main report on the date field. This would give you the data specific to the dates. You would then get the report level summary by summarizing the shared variables in the main report.

-LB