BusinessObjects Board

@Prompt

building reports desktopintelligence
#1

I have been searching BOB but I have not found the exact answer.

Is it possible to have two prompts and the user only have to fill in one of them? In Reporter in the conditions box I put the first filter prompt(Select a Section) then I have an OR condition and the second filter prompt(Select a file number). When I run the report it seems like I have to enter in both prompts even though I have an OR condition. Is this correct? Can’t I just have a prompt where I enter in one or the other?

Thanks
Lori

bachman :us: (BOB member since 2002-09-24)

#2

Prompts MUST be filled out.

What you could do is something along the lines of (oracle pseudocode):


TableName.ColumnName = @Prompt (...)
OR 'ALL' = @Prompt (...)

You still will have to provide a value, but by typing ‘ALL’ the query would return all records - see this Designer FAQ for more information

Andreas :de: (BOB member since 2002-06-20)