• Status: Solved
  • Priority: High
  • Security: Public
  • Views: 74
  • Last Modified:

SSRS 2008 R2 10.50.6220.0 - Duplicate Report Results for Multi-value Parameter selections

Experts - Need your help. I'm stuck. I created an SSRS report  (partner business review) that uses 7 datasets to populate the report (I created an additional dataset for the customer_id parameter).

The original design called for manually entering exactly 1 customer_id and then generating the report. Now, we need to change this to allow for the selection of multiple customer_id's (from a drop-down) and have a separate, unique, report generated, for each customer_id selected from the drop down. I'm sure for an SSRS expert this is easy however, in all my years creating SSRS reports, I haven't had this as a requirement and am desperately lost.

Can anyone help a new member?

Thank you to anyone/everyone for your feedback and help.

Jeremy
0
Jeremy Poisson
Asked:
Jeremy Poisson
  • 3
  • 2
1 Solution
 
ManjuIT - Project ManagerCommented:
You need to create one subreport.  With one parameter: Customer_ID.  That subreport is located in your main tablix by using the Subreport object, and it receives the Customer_ID parameter.  The parameter is actually the "magic" part through which you just need to create one subreport.
1
 
Jeremy PoissonPresidentAuthor Commented:
Awesome work, Manu. I will surely reach out to you again with any/all SSRS related projects.
0
 
ManjuIT - Project ManagerCommented:
anytime. please accept the answer & close this question please.
0
 
Jeremy PoissonPresidentAuthor Commented:
Great work!
0
 
ManjuIT - Project ManagerCommented:
Jeremy - Can you close out the live session?
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now