Forum Discussion

RussellBode's avatar
RussellBode
Icon for Helper I rankHelper I
11 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.

Rufyda's avatar
Rufyda
Icon for Super User rankSuper User
10 months ago

Hi

Enable automatic refresh for the dependent parameter:

Open the Pay Period Date parameter properties.

Under Available Values → Get values from a query, check:

“Refresh automatically when the preceding parameter changes”

Ensure its dataset uses the preceding parameter as input.

If this helps, please mark as Accepted Solution and drop a "Kudos"

  • RussellBode's avatar
    RussellBode
    Icon for Helper I rankHelper I
    10 months ago

    Hello I dont want the avaliable value should be there for date since i cant change the date then its remains uneditable if we have avalible rather than default

     

    could you also please specify where i have “Refresh automatically when the preceding parameter changes”?