locked
Parameter filter not working in child report - SSRS RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I have two reports, one summary report which will serve as a parent report and another is a detail report which is the child report. You can navigate to the child report, once you click a field which has a drill through action from the summary report.

    I don't have a problem passing the parameter values from the parent to the child report. My problem is, when I am trying to filter the child report using visible parameters which has default and available values from datasets, the child report does not show and filter the information. It only shows the information based on the parameter value it received from the parent report.

    Is there any workaround for this? Thanks in advance for your answers.

    manikantan

    Saturday, March 7, 2015 5:27 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi manikantan,

    Based on my understanding, you create a drill through action in a main report, and you also specify a parameter to run the drill through report in Action properties. After drilling through to the target report, you want to select different values from the drop-down list of the parameter to filter data, though the parameter has been passed from the main report, right?

    In Reporting Services, if we have specified parameters for the drill through report in a main repot, after drill through to the target report, the report is already filtered. At that moment, we can’t select the parameter values from drop-down list to filter drill through report. In a word, if we pass parameters from main report to drill through report, we are not able to filter report by selecting parameter values in a drill through report.

    In your scenario, if you want to filter drill through report after drill through action occurs, please don’t specify parameters for the drill through report in Action properties. Then when you drill through to the target report, you can select parameter values to filter data.

    Reference:
    Add a Drillthrough Action on a Report (Report Builder and SSRS)

    If you have any question, please feel free to ask.

    Best regards,
    Qiuyun Yu

    Qiuyun Yu
    TechNet Community Support



    Monday, March 9, 2015 11:43 AM