parameter value combobox

[TjS]

First let me apologize in advance for maybe writing this question in the wrong area of this forum. Please advise if wrong, where i had to write the question.

Question:
in the report designer i made a simple report (connected to sample db AdventureWorks) with 1 parameter.

I want this parameter to appear as a combobox (allow multiple values) with a listing of the contents of a field. But i cannot seem to do this.

The parameter with no values and filtering it at the datasource causes no problems, i can type a value when viewing the report and the contents of the report are related to the value, but i do not know how to let the parameter selecting more then one values, or selecting from the combobox at viewing the report

please advice
(hope my question wasn't to crypting, i am just working with the BIDS for two days now, so i am finding out how everything works a bit first)

 

[TjS]

have tried several things. Won't help though.

- made a parameter
- made another datasource from the same table
- used the other datasource for selecting query within the parameter
- filtered this within the report
result: none

please anyone?

 

[namliam]

If you want like a combobox kindof thing, you cannot do this using a parameter.

You will have to use a "search form", search the forum for that and see how you get on.

 

[TjS]

thanks for the answer.
I have maintained this by making a parameter with using with multiple values; adding default values results in a combobox in which i can select some options, but i cant seem to get it together with query values.

Anyhow, thanks for your information.