Access Pivot chart in Report

[Joek]

I have created a Pivot chart in a form. The data is stored in a Table.

I now need to display this Pivot chart in a report.

Any advice/help would be appreciated

Thanks in advance

 

[Axess08]

What a coincidence, I was just about to post the same exact question. I need
help on this issue as well; if anyone knows a good way to do this that would
be very helpful? I have tried using the subform/subreport control but of
course I only get a listing of the data that is stored instead of the actual
chart itself (even though it is the default view).

 

[Axess08]

I figured it out. You have to make a subform of your query (use autoform)
that you used to create your pivotchart and then use that form to create a
pivotchart there (the same way you would have in the original query). Then
after you save the subform, you can put the default view as "PivotChart" (and
save it again). After this you can add it as a subform/subreport in any
report in the design view. Of course in the report's design view it will have
your subform in design mode (showing all the parameters needed to make the
pivotchart), but when you view it in print preview it will be the actual
pivotchart. I can't take total credit for this revelation, I kind of pieced
this together from an existing microsoft page:
http://office.microsoft.com/en-us/access/HA010346001033.aspx

Cheers