Parameter Query in a Chart Report

  • Thread starter Thread starter Lee T.
  • Start date Start date
L

Lee T.

It appears that you cannot use a parameter query when
creating a chart. At least I couldn't. I got around it
but is there an easier way?

To do this I:

1. Build the parameter query as a make table query.
2. Turn off the warnings
3. create the Temp Table
4. Run the chart report off the Temp Table
5. Delete the Temp Table
6. set the warnings back on

Thanks,

LT
 
Lee:

That's one way to do it. The other way (on non-SQL/ADP dbs) would be if
your report itself uses the same parameter (or if you can include that
parameter on the main report,) then you can have the SQL for the graph
reference a control on the report by putting as a condition for graphs field
that is parameterized: [Report].[YourReportControlWithParameter]

HTH
 
Back
Top