Want to restrict out of 3 @prompts

32 Views

Hi Folks,

I have one Webi report which has 3 @prompts for Purchase order number, Serial number and Sales order number, User is supposed to enter any one value as these prompts are on OR condition. For example, I enter Serial number and rest as '*'.

This is fine as far as i use only one prompt with a known value. But when i pull all prompts and enter any one value, report keeps running for around 8 hrs and does not product any output.

So I want to restrict only one prompt. Like if user puts value for any one prompt, other prompts gets disabled. so Query will not perform full table scan and will search for records using only one value that is entered.

At the same time I want to keep provision of '*' also.

How to apply this functionality at Report level?