SSRS Report Allow multiple on showing 1st selection results

I have a Parameter setup to look for Return Types.  The parameter is looking at a query for the results and I have allow multiples selected but it only shows the results from the first selection.  What am I doing wrong?
sharris_glascolAsked:
Who is Participating?
 
Phillip BurtonConnect With a Mentor Director, Practice Manager and Computing ConsultantCommented:
Far too little information provided for me to assist.

The best thing I can do this is this - creating a multivalued parameter may require more than only clicking the "Allow multiple values" box.

It may be as simple as changing the SQL from "WHERE MyProduct = @MyProductID" to "WHERE MyProduct in (@MyProductID)"; but it may be more.

I can recommend the book "SQL Server 2012 Reporting Services Blueprints" - chapter 1 talks about multivalued and cascading parameters, and how to parse them.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.