BusinessObjects Board

Creating a join based on prompt value

building reports desktopintelligence
#1

Hi ,

I have report requirement in that I need to have a join condition based on the input prompt values based on two tables…

Ex :- Say If I have two different tables …Customer and Employee
an I have four input prompts namely City (mandatory) , State (optional) ,zip (optional) and country (optional).

My Initial join will always like this

Customer.city = Employee.city – if only city is passed in prompt

if the value for state is passed in prompt value then my join condition should be:-
Customer.city = Employee.city
AND Customer.state = Employee.state

if country is passed in prompt then :-
Customer.city = Employee.city
AND Customer.state = Employee.state
AND customer.country = Employee.country

Like this there can be any permutation and combination of prompt values…and I need to join the two tables based on the input prompt values…

can you anyone guide me on this issue.

Canton (BOB member since 2006-10-16)

#2

The above can be done by using cascading prompts. Topic is discussed here

Prompt equivalent to SQl query is the condition in Where clause. As you cant have null condition after the equla sign, so is leaving a prompt empty or trying to have prompts options. You wont be able to execute the query with the prompts empty

KhoushikTTT :us: (BOB member since 2005-02-24)

#3

Hi,

thanks for your reply…

I didnt get your logic.

Actually prompt values are passed through a interface …its not entered manually… Can you please elaborate it in detail.

Canton (BOB member since 2006-10-16)