'SSRS user defined parameter for subreports

I am new here and was wondering if anyone can help me. I am fairly new with SSRS and want to know if the following can be implemented in SSRS.

I have a Main Report that results a table from a stored procedure. The table results the following columns:

  • consumed item id
  • consumed item location
  • consumption date
  • produced item id
  • produced item location
  • quantity consumed

Is there a way after running the initial report, a user can pick and use one of the "produced item id" and "produced item location" result and run it through another report/sub-report?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source