Multi Prompts

system · April 22, 2010, 7:44am

Hi BOB users,

I have the next situation.

In my report i want to have 6 prompts.
But i want to let the users to use how many they want.
If they don’t want to filter by a prompt to leave that prompt empty.

Can I do that ? If I can can you give me some guideline.

The problem is(theoretical) if I put a report filter with the value from the report and the user leaves the prompt empty. The filter will take the empty string and will go filter by it.

Thank you in advance and have a great day,
Andrei Mircescu

masterg (BOB member since 2010-02-19)

system · April 22, 2010, 7:46am

The only way you can achieve is by including ‘ALL’ in the LOV.

Check this.

Jansi (BOB member since 2008-05-12)

system · April 22, 2010, 2:24pm

Hi Jansi,

Thank you for your reply but i can’t figure it out.

can you give me an example ?

I didn’t work with lov until now so can you tell me what it is ?

So i have a table named trip i want to put a prompt on it . when he choose something to filter from the choose if he choose nothing to filter on all.

Can you give me a step by step guide or an example. It would help me a lot.

Thank you,
Andrei Mircescu

masterg (BOB member since 2010-02-19)

MarkP · April 22, 2010, 3:02pm

Andrei,

From the link that Jansi suggested, use the two links that my bff jill posted.
There is also a step by step guide in the post below that one.

Regards,
Mark

system · April 22, 2010, 3:33pm

Hey Mark,

Thank’s for your reply.
I’m a little confused about what lov is. It’s a variable ?
That’s my biggest clue.

Thank you,
have a nice day

masterg (BOB member since 2010-02-19)

system · April 22, 2010, 5:16pm

LOV stands for a List of Values. It’s typically established in the Designer Module and it is a distinct list of values for the specific column. This allows a pre-staged list of available entries for use with prompts/filters.

digpen (BOB member since 2002-08-15)

system · April 23, 2010, 9:09am

i didn’t work on designer so much … can you point me to a tutorial or something like that ?

thank you,

Andrei

masterg (BOB member since 2010-02-19)

system · April 23, 2010, 9:19am

Please go through the two topics given in the suggested link. Also read the designer guide from SAP BO site.

Jansi (BOB member since 2008-05-12)

system · April 23, 2010, 10:15am

BusinessObjects® XI:
The Complete Reference:- page 242

[Moderator Note: Content deleted - Jansi]

Regards
Keerth

Keerth007 (BOB member since 2009-03-21)

system · April 23, 2010, 10:22am

You can always show the route to the matter, but not to copy and paste/upload what it has. Please read Rule 17. Thanks.

Jansi (BOB member since 2008-05-12)

system · April 23, 2010, 11:29am

@Jansi,

Sorry,I didn’t know that.

@masterg

try to follow this thread

Keerth007 (BOB member since 2009-03-21)

system · April 27, 2010, 7:34am

ok thank’s i will look

So , i didn’t create a LOV , i don’t know how to do that right now but is it on my priority list to learn how to make a LOV.

But i’ve managed to make multi prompts nice and easy.

I had to put 6 prompts so I made 6 conditions that are always true and after that i’ve put 6 filter on the report level.

I know that the sql will import me all the data but i didn’t know how to make a lov and i had a deadline.

I will comeback later at this report after i learn to do LOV

have a nice day

masterg (BOB member since 2010-02-19)