Combo Box or drop Down box

Question

 

Hello all and Merry Christmas

 

How do you create a drop down box on the report so the users can chose a value and conduct their search according to that value,  See I have a SP that when the users enter a parameter they get the results according to that paramter, I would like for the choose one rather then type it up.  Can anyone help please

Answer 1

 

 

 

I have a blog article about that here:  http://bobp1339.blogspot.com/2007/11/more-about-multi-value-parameters.html

 

Basically, in the Parameters screen in the report designer, populate your available values.  You can either hard code them in the report, or use a data set to populate them from a database.

 

peace

 

BobP

Answer 2

Hi,

To get a drop down its only possible in the report parameters.

For that you need to use a separate dataset set and in this dataset filter that exact column which one you want to populate in the drop down box.

then in the report parameter try to get that parameter from the specific dataset.

so that when you will run the report it will give you the drop down box to choose the parameter from that.

 

Hope it will work fine for you

Anyway please let me know if you get the solution

Thanks

Mahasweta

Merry Christmas

 

 

Answer 3

Hi ,

Did you get your solution?

If so please let me know

 

Thanks

Mahasweta

 

Answer 4

 

Thank you so much, I went into the report parameters and entered in the values worked like a charm