Why does my subreport only show on the first page?

  • Thread starter Paul from Battle Creek
  • Start date
P

Paul from Battle Creek

I have created a form to allow my users to scroll through their selected
customers and view a PivotChart of customer data. The PivotChart is housed in
a subform and as the user scrolls back and forth he sees the Customer name in
the Form body and the customer's chart in the subform. The Form and SubForm
are linked on the customer number. It works fine.

I have tried to duplicate this with a report should a user require hard copy
but when I link the Report/SubForm on customer number I get a chart only on
the first page. If I unlink the Report/SubForm I get a chart on every page
but it's the same chart every time showing an aggregation of data for all the
customers in the set being reviewed. I have tried putting the Customer Number
and SubForm in both the Detail section and the Customer Header section of the
report with the same results in both cases.

Any ideas would be greatly appreciated. Paul
 
Top