Reports - Displaying a chart based on a parameter type query

[Andy Davis]

I have developed a number of reports that are based on parameter queries
where the user enters criteria such as a date range and a sales rep say. I
want to be able to show a graphical picture in the form of a bar chart based
on the data within the report. Can I do this as when I have tried to insert
a chart on the report it displays an error saying that it doeds not
recognise the parameter criteria. Am I right to assume that maybe a chart
cannot be produced if it has used parameter inputs from a parameter type
query?

Any tips would be of great help

Many thanks in advance

Dawn Davis

[Arno R]

"Andy Davis" <ad******@westnet.com.au> schreef in bericht news:42******@quokka.wn.com.au...

I have developed a number of reports that are based on parameter queries
where the user enters criteria such as a date range and a sales rep say. I
want to be able to show a graphical picture in the form of a bar chart based
on the data within the report. Can I do this as when I have tried to insert
a chart on the report it displays an error saying that it doeds not
recognise the parameter criteria. Am I right to assume that maybe a chart
cannot be produced if it has used parameter inputs from a parameter type
query?

Andy,
Your assumption is wrong. Maybe Access has a problem to 'understand' the field-type of your parameters.
-- Is your report showing records without the chart?
-- Is your report with chart showing records when you don't use parameters?

--
Hope this helps
Arno R

[Andy Davis]

Dear Arno

I get the following error message " Microsoft Jet Database engine does not
recognise Forms!Menu!Reppicklist as a valid field name or expression".
The user would normally enter the parameter for the query via a form. I have
tried just run the query on its own with the values typed directly into the
query and this works ok when inserting the chart on the report and the
values are correct. However as soon as it is run as a parameter query I then
get the above error message.

Many thanks in advance.

"Arno R" <ar****************@tiscali.nl> wrote in message
news:42**********************@dreader2.news.tiscal i.nl...
"Andy Davis" <ad******@westnet.com.au> schreef in bericht
news:42******@quokka.wn.com.au...

I have developed a number of reports that are based on parameter queries
where the user enters criteria such as a date range and a sales rep say. I
want to be able to show a graphical picture in the form of a bar chart
based
on the data within the report. Can I do this as when I have tried to
insert
a chart on the report it displays an error saying that it doeds not
recognise the parameter criteria. Am I right to assume that maybe a chart
cannot be produced if it has used parameter inputs from a parameter type
query?

Andy,
Your assumption is wrong. Maybe Access has a problem to 'understand' the
field-type of your parameters.
-- Is your report showing records without the chart?
-- Is your report with chart showing records when you don't use parameters?

--
Hope this helps
Arno R

[Arno R]

Andy, I think you need this to 'tell' Access about your parameters:
Use the query-menu, menu item Parameters, enter the criteria EXACTLY
as you use them (cut and paste is safest) and enter the data type.

--
Hope this helps
Arno R

"Andy Davis" <ad******@westnet.com.au> schreef in bericht news:42********@quokka.wn.com.au...

Dear Arno

I get the following error message " Microsoft Jet Database engine does not
recognise Forms!Menu!Reppicklist as a valid field name or expression".
The user would normally enter the parameter for the query via a form. I have
tried just run the query on its own with the values typed directly into the
query and this works ok when inserting the chart on the report and the
values are correct. However as soon as it is run as a parameter query I then
get the above error message.

Many thanks in advance.

"Arno R" <ar****************@tiscali.nl> wrote in message
news:42**********************@dreader2.news.tiscal i.nl...
"Andy Davis" <ad******@westnet.com.au> schreef in bericht
news:42******@quokka.wn.com.au...

I have developed a number of reports that are based on parameter queries
where the user enters criteria such as a date range and a sales rep say. I
want to be able to show a graphical picture in the form of a bar chart
based
on the data within the report. Can I do this as when I have tried to
insert
a chart on the report it displays an error saying that it doeds not
recognise the parameter criteria. Am I right to assume that maybe a chart
cannot be produced if it has used parameter inputs from a parameter type
query?

Andy,
Your assumption is wrong. Maybe Access has a problem to 'understand' the
field-type of your parameters.
-- Is your report showing records without the chart?
-- Is your report with chart showing records when you don't use parameters?

--
Hope this helps
Arno R

[Andy Davis]

Arno

Many thanks for that. It worked and also gave the correct results in the
report.

Regards

"Arno R" <ar****************@tiscali.nl> wrote in message
news:42**********************@dreader2.news.tiscal i.nl...
Andy, I think you need this to 'tell' Access about your parameters:
Use the query-menu, menu item Parameters, enter the criteria EXACTLY
as you use them (cut and paste is safest) and enter the data type.

--
Hope this helps
Arno R

"Andy Davis" <ad******@westnet.com.au> schreef in bericht
news:42********@quokka.wn.com.au...

Dear Arno

I get the following error message " Microsoft Jet Database engine does not
recognise Forms!Menu!Reppicklist as a valid field name or expression".
The user would normally enter the parameter for the query via a form. I
have
tried just run the query on its own with the values typed directly into
the
query and this works ok when inserting the chart on the report and the
values are correct. However as soon as it is run as a parameter query I
then
get the above error message.

Many thanks in advance.

"Arno R" <ar****************@tiscali.nl> wrote in message
news:42**********************@dreader2.news.tiscal i.nl...
"Andy Davis" <ad******@westnet.com.au> schreef in bericht
news:42******@quokka.wn.com.au...

I have developed a number of reports that are based on parameter queries
where the user enters criteria such as a date range and a sales rep say.
I
want to be able to show a graphical picture in the form of a bar chart
based
on the data within the report. Can I do this as when I have tried to
insert
a chart on the report it displays an error saying that it doeds not
recognise the parameter criteria. Am I right to assume that maybe a chart
cannot be produced if it has used parameter inputs from a parameter type
query?

Andy,
Your assumption is wrong. Maybe Access has a problem to 'understand' the
field-type of your parameters.
-- Is your report showing records without the chart?
-- Is your report with chart showing records when you don't use
parameters?

--
Hope this helps
Arno R