Charts

[Question Boy]

I have been tasked to create a statistical report.

I need to create a pie chart by category by type. Thus I need to generate 3
charts (3 type) and there are 3 categories thus a total of 9 charts.

What I did, and please advise me if this is wrong, is created a report by
Categorie which has all three type charts. then I created a master report
which houses the 3 sub-reports.

Is this a correct approach or am I missing the boat.

Secondly, I now have been asked to prompt the user to select the year to
generate the chart for. I went into the underlying query and added a
criteria to it and now when I run the Master report I get prompted 9+ times
to enter the date, How can I set it up to only prompt me once for the year?

Thank you,

QB

 

[Duane Hookom]

You might be able to use a single report and use the link master/child to
filter each chart.

You should never use parameter prompts in queries. Always use references to
controls on forms.

 

[Question Boy]

I ended up doing as you suggested, but I am still suprised at how slow the
report is to open. It semmed much faster when I entered a value as the query
criteria rather than using a form value?

Thank you for your help,

QB