Optional prompts

system · October 13, 2009, 7:17am

Hello All,
I have a report with 3 prompts on Dname,Location,Ename.
These prompts are optional.It should be dispaly if I select any prompt 2 or 3 prompts.
Can you please suggest the way.

Kala Bhairava (BOB member since 2009-10-07)

system · October 13, 2009, 7:38am

It’s not clear what you need. Optional prompts can be set in the query of Web-I XI 3.x, but in Desk-I what you can do is to include ‘ALL’. Search for ‘ALL’ in B B, if this is what you need.

Jansi (BOB member since 2008-05-12)

system · October 13, 2009, 8:57am

I know how to include ALL for the objects but not clear how to implement prompts in Deski.Will you suggest me to create the prompts for this
Thanks in advance

Kala Bhairava (BOB member since 2009-10-07)

system · October 13, 2009, 9:25am

I also have pretty much same requirement,Help will be much appreciated.Thanks

Keerth007 (BOB member since 2009-03-21)

system · October 13, 2009, 10:03am

Use Webi XI R3.x, then you can build true optional prompts within the report.

Andreas (BOB member since 2002-06-20)

system · October 13, 2009, 10:12am

But we need to develope this Deski only.Will you please suggest me.

Kala Bhairava (BOB member since 2009-10-07)

system · October 13, 2009, 1:06pm

IMPOSSIBLE IS NOTHING…But i don’t know how to do in Deski

Keerth007 (BOB member since 2009-03-21)

system · October 14, 2009, 10:20am

Create a condition object for Prompt and use that into your report.

What issue you are facing in this.

Rakesh_K (BOB member since 2007-12-11)

system · October 14, 2009, 10:25am

As I said earlier, only Web-I 3.x allows us to leave a prompt optional. For Desk-I you have to include ALL in LOVs and then select it, as it is the only option. Or are we getting you wrong?

Jansi (BOB member since 2008-05-12)

system · October 15, 2009, 5:50am

Jansi,
Yes I got it now. Thanks a lot.

Kala Bhairava (BOB member since 2009-10-07)

system · October 16, 2009, 12:22pm

BusinessObjects® XI:
The Complete Reference:- page 242

Pseudo Optional Prompts
If you do not want the prompt to be mandatory to limit the number of rows, try the
following technique, originally suggested by Walter Muellner of Mercury Business
Solutions in Austria. The Where clause uses an OR statement to allow users to either answer
ALL or choose individual values from the list:

‘ALL’ IN @Prompt(‘Enter City or ALL’,‘A’, ‘Customer\City’,multi,)
OR
City.city IN @Prompt(‘Enter City or ALL’,‘A’, ‘Customer\City’,multi,)

This is a very creative approach to balancing user friendliness with prompting. When
users enter ALL, the first part of the condition SQL gets used (‘ALL’ IN ‘ALL’). Because
the condition statement uses an OR clause, the second condition is not evaluated. Conversely,
if users enter city names (or anything other than ALL), then the first part of the SQL is not
true and so it does not get used, while the second condition does. Of course, if ALL is a
possible data value in the City column, this poses a problem. The alternative is to use a
symbol such as * or %however, the risk is that users mix up true uses of these symbols (wildcards in certain databases). Finally, in order for this to work, the prompt in both
condition statements must be exactly the same or users will be prompted twice.

Keerth007 (BOB member since 2009-03-21)