Reporting Services (SSRS) Part 12 - Drop Down List Parameters

[@doupanpan7271]

enjoy watching these videos.

[@WiseOwlTutorials]

Happy to hear that you're enjoying the videos, thank you for watching!

[@krismaly]

This is an important episode. I am sure lot of customers may ask such feature. I enjoyed the video. Thanks a lot

[@PaulLundgren1970]

Excellent tutorial. The multiple items from a dataset section saved my bacon. Thanks so much.

[@RaviYadavGv]

Excellent videos.......... Thank you so much for preparing and posting all these videos.......

[@amilmammadov7189]

Hi, please explain when have you chosen "Use a dataset embedded in my report" in Dataset Properties ? In current tutorial on 3:22. Thanks a lot for tutorials.

[@sabotajj81]

so straight forward, and clear explanation. so helpful

[@babbraayasin]

Great video... very comprehensive.. you saved me atleast a day's reading.. Thanks

[@UpendraSingh-jn6lb]

Please update more videos !!! you are rock!! i don't have word to say thanks

[@MrShithater]

You my friend....you are amazing!!!!!!! Subscribed!

[@sujojohn2948]

Great Video.. Thanks for explaining it very deeply

[@pandarikkal]

wonderful videos. the presenter is a super master

[@DivInv]

Thank you for posting these tutorials, they are great.

[@shakhnozasalamova302]

Great Tutorial Andrew, Thanks a lot!

[@krismaly]

This is an important episode. I am sure lot of customers may ask such feature. Is there any way we can include icons next to dropdown list displayed values. For example director Steven and icon of his image? I enjoyed the video. Thanks a lot

[@abhilashamehra6117]

Amazing!! So helpful.

[@danilitr0]

Which visual studio are you using? Because my report viewer doesn't have option to filter directly...

[@darwichmohamed5491]

Perfect ideas Thanks from Egypt

[@cherisewoods9255]

Thanks for sharing these videos. I'm using a ds to populate a drop down list and only getting the first value in the list on my report. What if you have several values in your parameter (select all has over 50 values)?

[@thanzeelhassan]

You are amazing, sir !

[@elmortega]

when i click on add dataset in the dataset properties it doesnt guve me the query option. theres only a general tab. im using VS2012

[@narakdk]

I have a report that start on page two, how do I turn that off so it starts on page one? It is probably a Page Break added somewhere, but I cannot locate a tickbox that makes it work as I want.

[@WiseOwlTutorials]

Hi there, I think you'll have to hunt through the properties of whichever report items are sitting at the top of page 2 of your report. You can also find page break settings in Group Properties so check the Grouping pane at the bottom of the design window as well. I hope that helps!

[@narakdk]

Okay, this was embarrising. I overlooked the tickbox for the Page Break I alreade mentioned my self. Now there are no empty page 1 and this part works fine. Thanks for input

[@WiseOwlTutorials]

@@narakdk 😀 we've all been there! Happy to hear that you found the answer!

[@jodatkhan7648]

Secondly Sir,where we do need to go Management studio to pull out the diagram to see the relationship

[@mandeepsingh175]

After Specifying values in Parameters like Monday, Tuesday why you went to adjust Filters. Though We can select that without it.

[@MsSalim20001]

I have a dropdown list that have multiple values. When it contains values it's fine. When there is no value, it's blank, is it possible to print a message saying 'there is no result ?'

[@mckymini152]

I built report without parameter which is working fine and same report when i put parameters - i'm getting unable to connect to database. underlying database is teradata. my question is this parameters only works for SQL serever ?

[@christellesanhi6241]

Hi, just wondering is it possible to populate the drop down list using query from the dataset and an additional parameter apart from the dataset. If so, how can I do it? Appreciate your response. Thanks

[@jodatkhan7648]

Thankd for sharing these useful videos.I was successful in creating the MonthName Column but not able to get the DayName colum.I have used the expression (=WeekdayName(Fields!Day.Value) in calculated field.Although i am getting day names for only few days.Could you please help?

[@JobQuestUnveiled]

Any idea why I get the following error please? An error occurred during local report proccessing. The definition of the report is invalid. The report parameter (name) has a DefaultValue or a ValidValue that depends on the report parameter 'umlocationid'. Forward dependencies are not valid.

[@WiseOwlTutorials]

Hi Henri, my guess would be that you've set the Default Value of the Name parameter rather than the Available Values. Check the Parameter Properties for the name parameter first. I hope that helps!

[@danilitr0]

In the dataset properties only show me the General Tab

[@devlinch]

Very helpful! Thanks!

[@gwynhwfar]

These tutorials are really useful. In the first example I typed in all the days of the week for the parameter and used =WeekdayName(Weekday(Fields!FilmReleaseDate.Value)) for my Day field. However, when I select a day from the list at runtime I get the previous day. So, selecting Sunday gives me Saturday releases, Saturday gives Friday, and so on. What am I doing wrong?

[@gwynhwfar]

***** Thank you so much for replying so quickly. I'd figured it was something to do with the start of the week, but your expression is what I was trying to get. It now works for me. Thanks.

[@armansaleem3781]

gwynhwfar thank you so much for sharing the =weekdayname(weekday(Fields!FilmReleaseDate.Value)) Ive been messing with each and every item in common functions fr a couple of hours... May Allah bless you and Andrew

[@DadSonunboxing]

hi, i have a situation, i have a multi select drop down list. I would like to create a filter on multiple columns using a single dropdown list. eg :- Column A or Column B ( Search on column A value or Column B Value) how can i do it ?

[@spenn6367]

I'm unable to successfully preview my report with the second data-set as described in your video. It errors with a message similar to ... "When the report contains multiple datasets..." Please advise.

[@ranveermishra2]

i have also the same issue

[@MeaganWarncke]

I'm having trouble adding these fields to the header of my report. I need to show which (for example) Legislative District the data is for where Legislative District is one of the report parameters.

[@MeaganWarncke]

Awesome! Thank you!!!

[@anilthapa1218]

I have a quick question regarding the drop down list parameters: I want to put lets say site as my drop down parameter but each site has multiple customers and by following your instructions here, I am able to get the drop down site parameter but the issue that I am having is the site is redundant in my drop down list. Lets say, I have 2 sites (A, B). Site A has 3 customers and Site B has 2 customers. Now my drop down list is A,A,A,B,B. What do I need to do here to get just A, B in dropdown list

[@leahhunter3211]

I have the same problem

[@ferreirocar]

Thanks man you are great!

[@elmortega]

I cant see the desing and preview tabs im using VS 2012

[@MrIrrepressible]

Good tutorial and thanks for making in available for free. Do u have a vus aviyt passing parameters from ssrs to a stored procedure?

[@WiseOwlTutorials]

Hi there, we don't have a video on this but it's surprisingly simple to do! When you create a new dataset in a report, on the Dataset Properties dialog choose Stored Procedure as the dataset type and then select the procedure which defines the parameters you want to use. When you click OK, any parameters in the procedure will automatically create a corresponding report parameter. This is on my list of videos to create but it may take some time to get round to it.

[@MrIrrepressible]

@@WiseOwlTutorials u are star..thank u

[@anilthapa1218]

That certainly helps... Thanks a lot Really appreiciated

[@sudipchakraborty9283]

When I try to add new dataset in same data source I get error msg 'you have specified integrated security or credentials in the connection string for the data source, but the data source is configured to use a different credentials type. To use the values in the connection string,you must configure the unattended report processing account for the report server ' how can I handle this

[@ЮрийЛукашенко-й6к]

Sudip, do you still have this error? I have the same today

[@fatenalbajjari1993]

Thank you for your useful video, I want to connect dropdown list parameter with RDLC report using reportviewer in (asp.net+c#) please,I follow your video , but I do not know how to display the preview tab, can you help me please

[@chiraggardhariya7551]

Thanks. It is very helpful

[@mahnazrezahosseini173]

Hi. Thanks for video. I just want to load all rows when we run it and do not choose any filter. Is it possible?

[@raghavkhot7923]

I am also facing same issue. If you have got answer plz share here

[@ahmadawan847]

how to sort Parameter items (items in parameters )in ascending order

[@narakdk]

And how to make the report show the Default value of "(Select All)" ?

[@WiseOwlTutorials]

You can set the default value of a multi value parameter using the same dataset that you use to populate its available values. I hope that helps!

[@bigmacdaddy1234]

Amazing tutorials...thank you so much.

[@just3963]

Useful! Thank you! :)

[@hemukarnik]

i followed your steps but could not succeed

[@azizsallam1389]

great and loyal man to globe

[@krismaly]

Good

[@krismaly]

This is an important episode. I am sure lot of customers may ask such feature. Is there any way we can include icons next to dropdown list displayed values. For example director Steven and icon of his image? I enjoyed the video. Thanks a lot