Member Avatar for 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

  • 2 Contributors
  • 4 Replies
  • 88 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by Tank50
Member Avatar for Ramy Mahrous

Define it as Parameter.

Member Avatar for 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

Member Avatar for Ramy Mahrous

To allow multiple selection from report parameters check Multi-value

Member Avatar for Tank50

Hi

Thank you Ramy,It works.:)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.