SSRS Passing Multiple Parameters To Reports Part 17

preview_player
Показать описание
This video explains passing multiple parameters to SSRS reports.
Step 1: Populate all parameters with an option for user to select product
Step 2: Applying filter to get only those products which has been selected from the Multiple select dropdown list.
Рекомендации по теме
Комментарии
Автор

I've been struggling with the multiple value parameters for some time. This video solved my problem. Thank you very much!

etdwh
Автор

I enjoyed watching this video and recommend others to watch.
Parameters with choosing Multiple values and Totalling explained well.

Narrator talks friendly with audience.

Question:
You are working on the last video report. Instead of deleting Parameter you could have changed the properties to choose Multiple values and change other properties. Don't you think that would have worked?

What you are doing is fine but it flashed me above question in my mind that's all.

You are doing great.

Thanks for educating the community and appreciate your volunteer-ship.

Thanks a lot

krismaly
Автор

Thank you for you tutorial really helpful. :) I have a question, I hope you can help me. I have like three different parameters in my report. Right now I have the "select any" so that the user have the option of not to select any of the parameters and still able to run the report. The only thing they need to select is the date (this was requested by the user). Now the user has asked to me to have the option to select multiple options like you did here in "products" for all the parameters that are in the report. When I added the check-boxes and I run the report without selecting any option like I did before the report does not show any information. My question is can I still do this if added the check-boxes or no.  Thank you in advance for you help on this.

monik_v
Автор

nice presentation. you chose to use filters vs. having the parameter values pass back to the query and the WHERE statement handle the filtering.  I assume you could have done it either way but is there one method better over another and why?

sccheng
Автор

why did you remove '0' from Value(0) at 2:38

mujtubahasan
Автор

Hello, I was hoping this video was going to resolve my problem, but it didn't. So, hopefully someone can help.
I am able to set up the drop down parameters via a Query. When I select a single value, the report works, however, when I select two or more values, I get no returning records. I've seen people modifying their parameter expressions to:  =Join(Parameters!TerritoryIDs.Value, ", ") but this isn't working for me either.
Anyone have any ideas?

AntAntL