Hello all!!
I’ve got a few queries running on a single report. Can I apply a global prompt that would apply to all the queries?
G.
gmonny (BOB member since 2004-06-24)
Hello all!!
I’ve got a few queries running on a single report. Can I apply a global prompt that would apply to all the queries?
G.
gmonny (BOB member since 2004-06-24)
Sure. Create a prompt in the first query. Create conditions in the rest of the queries by, select an object, select an operator, then for the operand, select an existing prompt. This will give you a list of prompts that have already been used in this report. Select the prompt that you want to re-use. When the report is refreshed, the value of this prompt will be supplied to all the conditions it is part of.
Lee Drake (BOB member since 2002-08-15)
Thanks, Lee!!
gmonny (BOB member since 2004-06-24)