[SOLVED] LOV Prompt question

building reports webintelligence
1

Hi all,

In a DB table, I have the fields “Client Id” ( a numeric identifier of the client) , “Client Name” (The name of the client).

In the report I want the query to filter on a list of “Client Id”: SELECT … FROM…WHERE ClientId IN (List of Client ids) .

This list of clients should be prompted by the report. So something
SELECT … FROM…WHERE ClientId IN @Prompt(…) .

My problem is that - In the prompt - I want to show a list of clients with their ids and their names ( SELECT ClientId || ’ ’ || ClientName FROM clients ) but not just their ids ( SELECT ClientId FROM Clients ). In the query I want to filter on the ids only.

What should I do ?

Thanks in advance for you help,

R

jlinho (BOB member since 2009-05-12)

2

Edit the client ID LOV in universe. In the Edit LOV query panel, pull Client Name along with Client ID. This should work for you.

vinod_menon :india: (BOB member since 2007-04-09)

3

Thanks for your rapid answer… I didn’t even now that we can do that ! (I am a total beginner)

jlinho (BOB member since 2009-05-12)

4

Do you have access to Designer ?? (Universe creation)

Thanks

BOCP (BOB member since 2007-07-02)

5

Yes

jlinho (BOB member since 2009-05-12)

6

Did you tried what Vinod stated??

Thanks

BOCP (BOB member since 2007-07-02)

7

Sure I didi and it worked well

jlinho (BOB member since 2009-05-12)