Chart and repeated parameters

  • Thread starter Thread starter hermie
  • Start date Start date
H

hermie

I have a query with 2 parameters [month] and [year], from this query I make
a crosstab query also with parameter [month] and [year] From the crosstab
query I created a report. all works fine except that when open the report it
prompts many times for the parameters. Now I want to add a simple graph to
the report and here I have the problem, I cannot generated a proper report?
When I add a chart to the report I get the message that it not recognize the
parameters? Somebody have a trick to add a graph? Creating a graph in Excel
is 1000 times easier then in Access?? but I not want to be dependent from
excel to create a graph
 
Your criteria should come from text boxes (or other controls) on forms. Your
graph Row Source property is most likely a crosstab query. You would need to
open the Row Source in design view and select Query|Parameters and then
enter your parameters and datatypes:
Forms!frmA!txtMonth Integer
Forms!frmA!txtYear Integer
 
Hi Duane

This sounds for me acabadabra

I saw a post where you said that you should avoid using parameters in a
chart? I tried that out and it works
with the only problem that the chart show the X axes in alfabetical order
and not in the order of the events.

But to make live easier and to create rapid reports for selected periods
parameters are great, however I have the problem as mentioned in the first
post.

You advice is not clear to me, I not use a form to create my report I use
the crosstab query. Do I need to create a new form for my report?

hermie

Duane Hookom said:
Your criteria should come from text boxes (or other controls) on forms. Your
graph Row Source property is most likely a crosstab query. You would need to
open the Row Source in design view and select Query|Parameters and then
enter your parameters and datatypes:
Forms!frmA!txtMonth Integer
Forms!frmA!txtYear Integer

--
Duane Hookom
MS Access MVP
--

hermie said:
I have a query with 2 parameters [month] and [year], from this query I make
a crosstab query also with parameter [month] and [year] From the crosstab
query I created a report. all works fine except that when open the
Click to expand...
report
it
prompts many times for the parameters. Now I want to add a simple graph to
the report and here I have the problem, I cannot generated a proper report?
When I add a chart to the report I get the message that it not recognize the
parameters? Somebody have a trick to add a graph? Creating a graph in Excel
is 1000 times easier then in Access?? but I not want to be dependent from
excel to create a graph
Click to expand...
Click to expand...
 
If you want to use parameter queries, the solution is the same. Just enter
your parameters in the query parameters rather than references to the form
controls.

Showing an Axis in alpha order has nothing to do with the parameters. This
is based on how records are returned from the chart's Row Source property.

--
Duane Hookom
MS Access MVP
--

hermie said:
Hi Duane

This sounds for me acabadabra

I saw a post where you said that you should avoid using parameters in a
chart? I tried that out and it works
with the only problem that the chart show the X axes in alfabetical order
and not in the order of the events.

But to make live easier and to create rapid reports for selected periods
parameters are great, however I have the problem as mentioned in the first
post.

You advice is not clear to me, I not use a form to create my report I use
the crosstab query. Do I need to create a new form for my report?

hermie

Duane Hookom said:
Your criteria should come from text boxes (or other controls) on forms. Your
graph Row Source property is most likely a crosstab query. You would
Click to expand...
need
to
open the Row Source in design view and select Query|Parameters and then
enter your parameters and datatypes:
Forms!frmA!txtMonth Integer
Forms!frmA!txtYear Integer

--
Duane Hookom
MS Access MVP
--

hermie said:
I have a query with 2 parameters [month] and [year], from this query I make
a crosstab query also with parameter [month] and [year] From the crosstab
query I created a report. all works fine except that when open the
Click to expand...
report
it
prompts many times for the parameters. Now I want to add a simple
Click to expand...
Click to expand...
graph
to recognize
the
Click to expand...
Click to expand...
 
Back
Top