Possible to show a parameter value in report based on Microsoft Graph?

[Steve Newton]

Access Wizards,

I used the Chart Wizard to create a chart in a new Microsoft Access
report. To achieve the effect I wanted, I initially based the report
on a select query, and then changed the select query to a crosstab
query.

The crosstab query has two parameters: Year and CaseNumber

After a little fidding, the report produces the graph just fine. I'm
showing Months along the axis, the specified Year as the Series, and
"Number of critical incidents" as the Data.

The graph displays the Year value (e.g., 2004) in the graph legend
because Year is the series. However, although the graph supplies--as I
intended--data only for the specified CaseNumber the graph does not
show this value (e.g., CaseNumber 355).

I have tried to insert the [CaseNumber] field in the Detail section of
the report, but this doesn't work.

Does anyone know how I can make the CaseNumber parameter value show
somewhere on the report? The graph looks fine, but it begs the
question: "I see these are Critical Incident data for 2004, but which
CaseNumber is associated with these data?"

Many thanks,

Steve Newton
(e-mail address removed)

 

[Duane Hookom]

Assuming your parameters come from controls on forms (they should), you can
add a text box to your report with a control source like:
=Forms!frmGraphParams!txtCaseNumber

 

[Steve Newton]

Assuming your parameters come from controls on forms (they should), you can
add a text box to your report with a control source like:
=Forms!frmGraphParams!txtCaseNumber

Duane,

Thanks for your reply.

I'm probably not understaning you. In my case the report is based on
the crosstab query, which prompts me for the two parameters when I
startup the report. There isn't a form on which the CaseNumber appears

Given this, is there a solution?

Thanks,

Steve

 

[Steve Newton]

Assuming your parameters come from controls on forms (they should), you can
add a text box to your report with a control source like:
=Forms!frmGraphParams!txtCaseNumber

Duane,

It took a little head-scratching, but I got it. Works like a charm
now. Please disregard my previious perplexity.

Steve