Search code examples
reporting-servicesssrs-2012reportingservices-2005drillthrough

SSRS Drill through Parent report to Child report with 2 parameters

I want to drill through from Parent Report to Child Report, Where 2 columns from Parent acts as Parameter to child.

EXAMPLE DESIGN I made 2 parameters Hidden, because value will be retrieved by Parent report. But I m getting "The 'ColB' parameter is missing a value". I would appreciate any help.

Solution

  • You've not given any details about the report parameters on the child report and how you have assigned them

    Typically you would set an action on a textbox that is in your parent report. In the action properties, you would choose Go To Report and then choose the subreport name. Then you would add parameters and set the parameter name to ColA (case sensitive - this the parameter name in your child report) to your ColA field ([ColA]) from your parent report dataset (you should be able to choose this from the parameter value dropdown), then repeat for parameter @ColB.

    That's all there is too it. If this does not help, show your settings in the TerxtBox properties Action tab.