Drop Down List

Question

Drop Down List

Raghavender Chavva

SSCrazy Eights

Points: 8669
More actions
August 18, 2010 at 8:14 am

#239162

Hi All,
How to include a drop down list to a report, and here if I select the value as "ALL" from that drop down list, it should show all the information related to that column or if I select any value, it should show the information based on that coloumn condition.
Please suggest me how to develop this one ?
Its urgent.
Thank You.
Regards,
Raghavender Chavva

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

vishal.gamji SSCertifiable Points: 6126 More actions · Answer 1

Have you stored procedure (that lists the drop down values) take a default value of 'ALL' and when the input is default 'ALL' it should return everything. Configure your report drop down input based on this.

Raghavender Chavva SSCrazy Eights Points: 8669 More actions · Answer 2

vishal.gamji (8/18/2010)
Have you stored procedure (that lists the drop down values) take a default value of 'ALL' and when the input is default 'ALL' it should return everything. Configure your report drop down input based on this.

Sorry...I didnot understand perfectly... if you dont mind can you please eloborate...if possible with small example ?

Thank You.

Regards,
Raghavender Chavva

Raghavender Chavva SSCrazy Eights Points: 8669 More actions · Answer 3

Stilll no replies, can any body please help me in this ?

Thank You.

Regards,
Raghavender Chavva

Ganesh Lohani Hall of Fame Points: 3091 More actions · Answer 4

You need to create a multivalue parameter in your report.

Steps:

1. Open the report in BIDS and click the data tab.

2. Create a new data set, let's say CustomerTypeList. - In my case, I have a table tblCustomer and I want to select the customer's information by CustomerType field and I have 5 types of customers called A, B, C, D, and E). So the query for the new data set would be like SELECT DISTINCT(CustomerType) FROM tblCustomer. It will returns 5 rows.

3. Click Layout --> Report ---> Report Parameter ---> and add a new parameter .

4. Configure the parameter as Name = Customertype, Data Type as String, Prompt = Select the Customer Type, Check mark the Multivalue Box,

5. In available value, select from query option. In dataset choose CustomerTypeList that you created in step1, value field = CustomerType, and label field = CustomerType, and click OK.

6. Go to preview tab and run the report. You should be able to select one or more value from the drop down list.

I hope it would help you

Ganesh Lohani Hall of Fame Points: 3091 More actions · Answer 5

If you did not understand the concept used in my previous post,

Please review the following link

http://msdn.microsoft.com/en-us/library/aa337292.aspx

Thanks

Dom Horton SSCrazy Points: 2202 More actions · Answer 6

Hi,

If you're still having trouble, this may help:

http://sqlreportingservicescrystalreports.blogspot.com/2010/05/select-all-option-ssrs.html

thanks,

Dom Horton

Raghavender Chavva SSCrazy Eights Points: 8669 More actions · Answer 7

Hi,

Thanks for your replies, these are very Helpful.

Thanks Once again.

Thank You.

Regards,
Raghavender Chavva

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 8

Ganesh Lohani (8/25/2010)
You need to create a multivalue parameter in your report.
Steps:
1. Open the report in BIDS and click the data tab.
2. Create a new data set, let's say CustomerTypeList. - In my case, I have a table tblCustomer and I want to select the customer's information by CustomerType field and I have 5 types of customers called A, B, C, D, and E). So the query for the new data set would be like SELECT DISTINCT(CustomerType) FROM tblCustomer. It will returns 5 rows.
3. Click Layout --> Report ---> Report Parameter ---> and add a new parameter .
4. Configure the parameter as Name = Customertype, Data Type as String, Prompt = Select the Customer Type, Check mark the Multivalue Box,
5. In available value, select from query option. In dataset choose CustomerTypeList that you created in step1, value field = CustomerType, and label field = CustomerType, and click OK.
6. Go to preview tab and run the report. You should be able to select one or more value from the drop down list.
I hope it would help you

Superb...but also modify your inline query or S-Proc with the IN clause

Raunak J