BusinessObjects Board

How to pass all values in a prompt

I have used the search and couldn’t get answers. I have 5 prompts in the conditions for my report.

Division Equal to prompt (‘Enter Division’)
Deptid Equal to prompt (‘Enter Dept Id’)
Account Equal to prompt (‘Enter Account’)
Fiscal Year Equal to prompt (‘Enter Fiscal Year’)
Accounting Period Equal to prompt (‘Enter Accounting Period’)

My requirement is the users might give a combination of values lets say

Division - 110
Dept - 220
Account - 330
Fiscal Year - 2006
Accounting Period - 10

or they want all the data without any restrictions. I tried using % sign and it gives an error. ‘No Data to fetch’. I have confirmed in SQl that there is data to fetch.

Any inputs appreciated
Thanks in advance.


DWHUser (BOB member since 2005-08-29)

% only works with the LIKE (Matches Pattern) operator.

Do a search for Optional Prompt* and you’ll see what you’re looking for.


Steve Krandel :us: (BOB member since 2002-06-25)

Hi,

please have a look at this Designer’s FAQ to get the idea how to accomplish what you need.


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

Thanks for the responses. I have used * and I get an error ’ No data to fetch’. As I have mentioned earlier The query does have data (Checked in SQL).

We are using DB2 UDB database and the report is using contexts.


DWHUser (BOB member since 2005-08-29)

You looked here? FAQ: Designer

You will need to show us the SQL definition of your object. Then we can help you.


Steve Krandel :us: (BOB member since 2002-06-25)

Thanks Steve and Mareck. Now I am able to pass all values.


DWHUser (BOB member since 2005-08-29)