Hi all,
I have a business requirement where - Five prompts will be needed. Only the first prompt will require that a value be entered. Prompts that are left blank should be set to null.
To go strictly by your requirement you will have to do some special coding, as BusinessObjects does not allow you to leave prompts empty. Or you can investigate this entry in the Designer FAQ that discusses how to allow a user to enter the keyword “ALL” and select all values from the database.