Embedded PivotCharts in Access Reports

J

JAY-USC

I designed a report with embedded graphics of performance measures for a
single region. The region is selected from a parameter form and a new
report run for each region.

Now my management wants an "ALL" selection for a page per region --
(without having to specify each region separately). The query is correct
and each region's data is on a separate row.

I built the report using an embedded Autoform: PivotChart feature (in
Access) to generate the graphics. But when the option of "ALL REGIONS" is
selected, the report produces only 1 graph whose data is a summary of the
data for all regions, rather than a multiple-page report with a graph for
each region.

The graph is embedded in a region header section that pages correctly (when
the graph is deleted from the report).

I did not use the "Insert chart" -- the graphics were so much "snazzier"
using the Autoform:pivotchart.

How can I get the results I need? Thank you in advance for your help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top