BusinessObjects Board

Using 4 prompts; need to use them seperately in a query

I’m using 4 prompts to select data for my report.

Year, Week, Customername, Projectnumber.

I like to accomplish that a user can fill 1 or more of the 4 prompts to select the desired data. (so one or more prompts can be left empty)

for example … user only knows year and week, but doesnt know the customername and projectnumber.

I don’t have the slightest idea how to do this.
Can anyone help me out on this one ?

Thanks in advance.


Henkmansys (BOB member since 2007-05-31)

Rather than leaving them empty, what you want to do is have the option for the user to select ‘All’ customer name or project number. Try searching in this forum for something like ‘prompt all’; I am sure there are plenty of posts that will help you.


Gillian :uk: (BOB member since 2005-08-18)

Thanks, will do a search !


Henkmansys (BOB member since 2007-05-31)

By the way, welcome to B:bob:B!

I also suggest to have a look at the first 2 links in the Designer FAQ (which is a sticky topic, always on the top in Semantic Layer forum).


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

Thanks ! :smiley: Great to see this forum is so “active”


Henkmansys (BOB member since 2007-05-31)