Dear all,
I'm building a report with some non-parameterized prompts valid for more than 1 queries.
I'm linking the prompts in the queries with the filter as [ORDER] IN ?Parameter?
Parameter is a text box prompt with multiple values and multiple lines
However, I need to make this prompt as optional.
I have already selected this while building the prompt, but if I run the report and I do not select any Parameter, I cannot go ahead.
I'm assuming this is due to the "IN" filter.
Is there any solution for this?
Thanks,
D
The #Prompt# syntax allows you to make the parameter optional. The ?prompt? syntax does not.
Dear all,
My fault, putting also the filter as optional it works.
Newbie's mistake.
Thanks a lot.
KR,
D