468,765 Members | 1,127 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,765 developers. It's quick & easy.

Reports - Displaying a chart based on a parameter type query

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
4 5293
"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
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
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
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.

Similar topics

1 post views Thread by Joris Kempen | last post: by
2 posts views Thread by mrwoopey | last post: by
9 posts views Thread by Patrick.O.Ige | last post: by
4 posts views Thread by touf | last post: by
1 post views Thread by access baby | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by Marin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.