Reporting Services

[Tank50]

Hi

I use the reporting services to generate the report.I use query like
"Select Distinct(ID) from Table1".In that query Its generate the number of ID ,So In report user able to several "ID" at one time,so I think if I can use combo box then user can select ID which they want,but problem is how I do that and I think if I add combo box then its easy,So how I add combo box into my report.

Thank
Tank50

[Ramy Mahrous]

Define it as Parameter.

[Tank50]

Hi

Thanks Ramy,but yes I have to use it as a parameter,but there is distinct ID like 1,2,10,20,etc ,So i want to select the several Id at one time,like "1","2","10".So cant I create combo box? ,without create text box to enter ID.

Thanks
Tank50

[Ramy Mahrous]

To allow multiple selection from report parameters check Multi-value

[Tank50]

Hi

Thank you Ramy,It works.:)