Report request parameter twice

I suspect I may have painted myself into a corner here.

I have a report that works fine. I wanted to add a graph to it and I placed it in the page footer of the report. I also works fine.

The first query in the process asks for a BETWEEN dates parameter. Both the tabular report and the graph use the same query ultimate query and their control.

When the report runs it first asks for the dates. It run for a while and asks for the parameters again (this time for the graph)

Again, the graph is in the page footer, not as part of a sub report or anything.

Is there a way that I can prompt once for the parameter and satisfy the requirement for the tabular report and the graph?

Thanks
tmccar10Asked:
Who is Participating?
 
Jim HornConnect With a Mentor Microsoft SQL Server Developer, Architect, and AuthorCommented:
>The first query in the process asks for a BETWEEN dates parameter.
>It run for a while and asks for the parameters again (this time for the graph)
Then this behavior is by design.

The only way to avoid the double-prompt is to have your value on a form somewhere, then in your query(ies) instead of [Enter a date here] as a parameter, you can use [Forms]![That Form Name]![That textbox name]
0
 
tmccar10Author Commented:
Thanks Jim

I knew that was a way to do it. I was looking for any other way.

It worked perfectly and was lest of a hassle than I anticipated.

Appreciate the help and the quick response.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.