BusinessObjects Board

Entering info for 1 of 2 prompts

building reports webintelligence
#1

Is there a way to have a prompt for a user to enter either the account # or loan # but not both?

For instance:

Date = prompt
City = Atlanta
Account # or Loan # = prompt

Hope this makes sense.

Thanks.

T

TMullan :us: (BOB member since 2007-03-08)

I want to create multiple combo's
#2

Hi this is not possible in Webi and Deski. in both the prompt at least you need to pass one dummy value. then only Run Query button activates.

through SDK we can do such kind of requirement.

Regards
Satya

Vallabhaneni :us: (BOB member since 2005-04-18)

#3

Like Vallabhaneni mentioned, a dummy value would be necessary. You could put in a default value for both the prompts and make it not persistent; not persistent in the sense, each time the report is refreshed, the default value would come up and the value last entered by the user will NOT BE PERSISTENT. If the user needs to enter a value for one of them he could go and change it.

The following is the syntax:

@Prompt('Account?,'c',,mono,free,Not_Persistent,{'None'},User:2,)

User:2 - this is jus for the order in which the prompt would appear.

Also, for your query to run with the default value you might have to incorporate a case statement internally. You could refer to the first post in the Designer FAQ.

https://bobj-board.org/t/15227/2

nithya_raj (BOB member since 2007-02-03)

#4

Thank you for the responses. I was afraid it may not be possible.

T

TMullan :us: (BOB member since 2007-03-08)

#5

Why not? :slight_smile: could you elaborate?

nithya_raj (BOB member since 2007-02-03)

#6

We found a very simple solution.

Both objects are included in the query panel as a prompt using “or” with the same wording for the prompt instruction. This way only one prompt appears and the user can enter either value.

Thanks to everyone for your responses.

T

TMullan :us: (BOB member since 2007-03-08)