Forum Discussion

RussellBode's avatar
RussellBode
Helper I
10 months 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
    10 months 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.

RussellBode's avatar
RussellBode
Helper I
10 months ago

Hey v-ssriganesh  any update?

when i am changing payrun schdule it update pay period then i can upodate date from and to

RussellBode's avatar
RussellBode
Helper I
10 months ago

v-ssriganesh 

tried one more thing

added test oaremetrer in between where the value of pay period na dtest i  same but if i just disable test now means hide or keep internal then  its not working may i know why?