Multiple queries- same input

[Guest_imported]

I have a report that contains 2 queries with prompts. Is there any way to have the same Product ID the user enters in Query 1 be automatically used in Query 2? Right now, the user has to enter the same Product ID twice. Thanks.


1st Query prompts
=================
Product ID
Beginning Date
Ending Date

2nd Query prompts
=================
Product ID

 

[ATP]

If the queries are in the same report then when setting a condition to equal a prompt, select the "Show List of Prompts" option (not the "Type a new prompt" option).

This will list any prompts that have already been used in the report, so the prompt from query 1 can be selected.

 

[bensonpa]

Just to expand on the above comment: All prompts with the same text (case sensitive) will be displayed only once to the user. So you can re-usea prompt as many times as you need within the same document either by choosing the prompt from the list (as above) or by typing in the same text. This also applies to any prompt which exist in the universe.