Prev: Loopup Box
Next: Combo Box Search
From: Barry A&P on 15 Apr 2010 13:16
No idea if you are still working on this but i see it is still posted as
un-answered you are right a pivot chart is a form but it can be put on a
report by either dragging the chart from the database window to the reports
design view or use the Subform/Subreport control and choose an existing form.
you should be able to put them all on one report.. you may have to change
the link master fields property if the charts are not somehow linked to the
reports data but that should be easy enough..

Barry

"dandc0711" wrote:

> Unfortunatly, they are not reports but forms. The Create pivotchart option is
> only availble in a form due to the custimization allowed in pivotcharts. I
> tried doing something similar with a master form and subforms but the
> subforms were just empty.
>
> "Barry A&P" wrote:
>
> > Im sorry im not an expert on pivot charts but when you say Chart i believe it
> > is a report and you should be able to create all four of your pivot chart
> > reports and save them seperately and then create your master report with four
> > subreports based on your individual charts..
> >
> > Sorry if this is way off base..
> > Barry
> >
> >
> > "dandc0711" wrote:
> >
> > > I have a series of pivot charts created in Access and I'd prefer to be able
> > > to show them all at once on one screen. Normally I'd do this in Excell since
> > > it would be cake to sqeeze them all together but in this situation I need the
> > > conditional formatting of pivot charts that access provides. So is there a
> > > way to put all the charts on one "thing"?
> > >
> > > I've tried putting them as subforms on a new form but they just come up
> > > blank, same for trying to put them on a report.
> > >
> > > -Thanks
 | 
Pages: 1
Prev: Loopup Box
Next: Combo Box Search