I want the user to be able to select a specific employee (for example) by entering the few letters of the name as "JONES%"; then they could select that specific employee and receive the report. I have been unable to accomplish in SSRS 2008. Seems simple enough. Any ideas?

Have you tried Cascading Parameters? Lesson 2: Adding Cascading Parameters to a Report Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM

Cascading doesn't work. I may need to use as a subreport. I'm a former main-framer. What user wants is to type in "Jones", or "Qua", and get back a list of available names that begin with a character string. And then select the specific "Jones" they were interested in. In this case the "cascading" relationship is not known in advance.

So you offer the alphabet for for the first 3 letters (3 prompts + final cascading prompt)? Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM

There are 234 combinations of "Jones" out of 32,000+ employees. I'm just as well off presenting the full list of 32,000 employees and letting them select the one they want.

This is what I did. It works perfectly. 1. Using the Person.Person table in AdventureWorks2008 2. I defined the first parameter LastNamePrefix on Dataset2 as: SELECT DISTINCT LastName FROM Person.Person WHERE LastName like @LastNamePrefix+'%' 3. Dataset1 is the following: SELECT * FROM Person.Person WHERE LastName in (@LastName) 4. LastName parameter is multiple select with value from Dataset2 (LastName, LastName) First the user is prompted to enter LastNamePrefix like "SMI" Second prompt for LastName offers multiple selection: SELECT ALL, Smith, Smith-Bates Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM