Parameter Query in a Chart Report

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
 
S

SA

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
 

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

Similar Threads

Parameter Query and Report 1
Bound Chart in Report Issues - Access 2007 4
Show query Parameter in Chart? 6
Display query parameters in a chart 5
Passing a parameter to a Chart object in a report 1
Adding a chart to a report with a parameter query 5
Placing textbox linked to parameter on a chart 2
Parameter Query In Report Title 3

Top