Report request parameter twice
Posted on 2007-10-01
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?