Home Forums Reporting Services Reporting Services 2008 Development Cascading drop-downs RE: Cascading drop-downs

  • February 25, 2015 at 6:28 pm

    #1780102

    DerbyNeal (2/25/2015)

    You would handle this in the default value for each child parameter. Make the default value the same as the available values

    Hi Alan,

    Thank you for your reply, I appreciate your response.

    The thing is... The requirement specifies that the Available vales are different from the Default values, that is why I created a different dataset!!!

    i.e. The available values are 0,1,2,3,4 whereas the default should only include 0,1,2,3 (4 is NOT required as a default)

    Unless I'm not reading your explanation correctly, it doesn't make sense that the values have to be the same in each. If that is the case, why bother having BOTH the Available and Default options?

    Sorry to reiterate but only the previously selected child records remain 'ticked', yet (in this instance) by additionally selecting '4' to the Parent, the relivent Customer I and Customer J records are un-ticked although they would now appear (since the update) in the child drop-down

    Regards and Thanks again,

    My apologies, I misunderstood your requirement. I don't have a solution :(. The only way I have seen this thing handled is by handling this outside of SSRS via .NET web form.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001