Forum Discussion

RussellBode's avatar
RussellBode
Icon for Helper I rankHelper I
1 year ago
Solved

Date parameter not getting refresh after updating previous parameter

      Hello i m selecting Parameter select the Pay Period date shows just fine     if i change the paramter it just not working and updating dates   any thoughts    
Need Help
  • v-ssriganesh's avatar
    v-ssriganesh
    1 year ago

    Hello RussellBode,

    The Test parameter only works when visible because SSRS only auto-refreshes dependent parameters (From/To) when a visible parent changes. Hidden/internal parameters break the cascade. Remove the Test parameter, fix the "Date" dataset to return real dates (PlannedPayPeriodDateStart AS StartDate, PlannedPayPeriodDateFinish AS EndDate), set correct Value fields, enable Always refresh in Advanced tab for From/To, and order parameters correctly Pay Period → From → To. This will auto-update dates instantly on Pay Period change. Try and confirm.

    Thank you.

v-ssriganesh's avatar
v-ssriganesh
Icon for Community Support rankCommunity Support
1 year ago

Hello RussellBode,

We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.

Thank you.