[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 221
  • Last Modified:

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
0
tmccar10
Asked:
tmccar10
1 Solution
 
Jim HornMicrosoft 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

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now