Help with prompts

[kevinko]

I am wondering if the scenario below is possible in Business Objects.

I want to prompt the user for a value called application code. If they enter a value of 1 then I want to prompt them for a language code value. If they do not enter a value of 1 then I do not want to prompt them for a language code at all. It is similar to a nested prompt except that I do not want the prompt to show up unless the application code value is 1. I would be alright with them entering the value and clicking run and then having that next prompt show up if the application code is 1.

Any thoughts you have on this would be much appreciated. Thanks.

 

[skrandel]

Nothing I can think of. Prompts are gathered before the SQL is executed, so there is not way to do this. You'd have to do something with VBA to gather up the prompts and then pass what you need to the SQL.

You would still have to have both prompts, you'd just have to use the 1-many-all method. Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com