Parameter in report with chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report with a chart based on a query with a "choose month" parameter
and I want the chosen month to appear on top of the report. How can I make
the chosen parameter appear on the report?

Thank you.
 
I have a report with a chart based on a query with a "choose month" parameter
and I want the chosen month to appear on top of the report. How can I make
the chosen parameter appear on the report?

Thank you.
Click to expand...

Add an unbound control to the Report Header.
Set if's control source to:
="For sales for the month of " & [Choose Month]

If [Choose Month] is entered as "September" that's all you need do.

However, if [Choose Month] is entered as a month number. i.e. 9 for
September, then you might want to use:

="For sales for the month of " & MonthName([Choose Month])

Note: The text within the brackets must be identical to the bracketed
text in the query.
 
Sorry to bother again, but I still have no solution. I tried your suggestion
and had tried before some "variants", but keep having the same mistake: "
#Name? ". What can be happenning?

Question: what do you mean by "unbound control"? A textbox?
Thank you.

fredg said:
I have a report with a chart based on a query with a "choose month" parameter
and I want the chosen month to appear on top of the report. How can I make
the chosen parameter appear on the report?

Thank you.
Click to expand...

Add an unbound control to the Report Header.
Set if's control source to:
="For sales for the month of " & [Choose Month]

If [Choose Month] is entered as "September" that's all you need do.

However, if [Choose Month] is entered as a month number. i.e. 9 for
September, then you might want to use:

="For sales for the month of " & MonthName([Choose Month])

Note: The text within the brackets must be identical to the bracketed
text in the query.
Click to expand...
 
Take your criteria value from a control on a form. A parameter query for a
chart control can't pass its value back to the report.

Controls on forms have much more flexibility and can be reference on the
report, in record sources, and in row sources.

--
Duane Hookom
MS Access MVP


Francisco F. said:
Sorry to bother again, but I still have no solution. I tried your
suggestion
and had tried before some "variants", but keep having the same mistake: "
#Name? ". What can be happenning?

Question: what do you mean by "unbound control"? A textbox?
Thank you.

fredg said:
I have a report with a chart based on a query with a "choose month"
parameter
and I want the chosen month to appear on top of the report. How can I
make
the chosen parameter appear on the report?

Thank you.
Click to expand...

Add an unbound control to the Report Header.
Set if's control source to:
="For sales for the month of " & [Choose Month]

If [Choose Month] is entered as "September" that's all you need do.

However, if [Choose Month] is entered as a month number. i.e. 9 for
September, then you might want to use:

="For sales for the month of " & MonthName([Choose Month])

Note: The text within the brackets must be identical to the bracketed
text in the query.
Click to expand...
Click to expand...
 
Back
Top