Filters

[phoenixfire]

There are two columns in one table. Emplid and SSN.
One SSN is associated with multiple Emplids.

Need to create a report with a prompt for emplid (textbox prompt).  But when the user enters the emplid, it should query the table for the corresponding SSN and then display all the emplid's associated with the SSN including the one entered by the user.
For eg. If I enter emplid 10000 and the ssn associated is 999999999. It should display all the emplid's for this SSN namely 10000 and say ABCDEFG.
Any help is greatly appreciated.
Thanks a lot in advance

      
   

[anirudha]

HI There,

I think this possible using multiple queries in report studio.

Query1: Get Emplid, SSN . Filter Emplid using ?Emplid? parameter (entered by user).

Query2: Get SSN,Emplid and all other require fields in this query. Dont use any filter in this query.

Now create a new Query3 which join of Query1 and Query2 based on SSN existing in both of them.
Once your join works you should be able to derive elements from either of the queries.

Let me know if this works or helps in anyway.

Anirudha.

[almeids]

Just set up your prompt so that SSN is the "Use" value, Emplid is the "Display" value.  The filter your report with

.[SSN]=?param?