BusinessObjects Board

Can we crate Optional promts??

Hi,

Can we create optional prompts in Business Objects?
I have one reports it is normally having 4 parameters. But I need the fourth one as optional prompt?If I pass three values to that report it sholuld ignore the fourth prompt and run the report.

Please help me in this manner.


Naveen V (BOB member since 2005-01-27)

Hi,

it is not possible not to provide the value for the prompt.

However, a possible workaround for you in this case can be using ‘ALL’ in the prompt. It means when the 4th prompt will be filled with ‘ALL’ value then the condition based on this prompt will not limit the resulting dataset. Please have a look at first 2 posts in Designer’s FAQ


Marek Chladny :slovakia: (BOB member since 2003-11-27)

I don’t know how to use the @Prompt function and make it optional. What I usually do to workaround this is create a special prompt with an OR condition in it, like this:

clientnumber=@prompt('Specify client number of % for all','A', client.number, mono, free) OR '%'=@prompt('Specify client number of % for all','A', client.number, mono, free)

This way the user can enter the % sign which result in an always true condition so all client numbers are allowed.

You can also search the board for other workarounds using prompts.

Hope this helps,
HenkK


HenkK :netherlands: (BOB member since 2004-03-02)

Hi,
One way of doing it with dimensions,
as "matches Patters “%%”

this worked for me with dimensions
including whole numbers.

See if this this works for you.


Omkar Paranjpe :us: (BOB member since 2006-02-13)