RE: Report Parameters

[allyne]

Hello,

I'm using the reporting module out of SQL Server 2005. The dataset comes from a stored procedure where the outcome looks like the following:

Person_Name Application
Test1 App1
Test1 App2
Test2 App5
Test2 App3
Test2 App2

What I would like to do is create a paramater with a distinct Person_Name But can't seem to get the parameter to work that way and it needs to be tied to the stored procedure. I would like to parameter to look like:

Test1
Test2

Any Suggestions?

Thank for you help!

 

[PWise]

I would like to parameter to look like:

Test1
Test2

As Oppose to ???

 

[allyne]

Currently it looks like:

Test1
Test1
Test2
Test2
Test2

I created a new data set for distinct values and now have the parameter looking the way I want it. Now the only problem I'm having is I want the user to be able to select multiple values. I have multiple values checked and the parameter alows you to select multiple values but the report only shows the first value checked. Any Ideas?

Thanks again for you Help!