By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,222 Members | 1,730 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,222 IT Pros & Developers. It's quick & easy.

Reports - Displaying a chart based on a parameter type query

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
"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
Nov 13 '05 #2

P: n/a
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
Nov 13 '05 #3

P: n/a
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

Nov 13 '05 #4

P: n/a
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

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.