What do you mean my user input? Are you refering to promts or am I
mistaken? Just in case you are, when you create promts for end user input,
they can be passed on for all queries in that report. They just have to be
named the same name. For example, if you created a prompt that asked:
Please enter beginning and ending transaction dates, this prompt could be
used for all of your queries that had the condition for transaction dates.
If this isn’t close to what you were asking, please specify.
Report Script isn’t even required to handle this, as this can be achieved
by means of a subquery (provided that a single key object exists which you
can use to link both queries):
First, build the query you want to perform on the first result set - add
the condition (with prompt) to the query conditions - add the key object to
the query conditions with operator “InList” and operand “Create a subquery”
then, build the subquery using the same prompt in the query conditions.
Note that the subquery corresponds to the first query you mentioned in your
posting, whereas the main query corresponds to the second query. Thus,
the subquery will perform the first selection (result set), and the main
query performs a subsequent selection on the first result set.
I think this should help you out. Good luck,
mirko.