• amadeu_j (7/4/2013)


    So I can not put any parameter by default?

    You can put a default on a parameter. You just need to make the dataset that calculates motherday dependend on the first parameter.

    This thread goes deeper into the problem of cascading parameters not refreshing:

    http://social.technet.microsoft.com/Forums/sqlserver/en-US/40397ac3-c17e-49f7-821f-41b4ee0b39cb/ssrs-2008-r2-cascading-parameters-not-refreshed-on-changing-parent-parameter-values

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP