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.

v-ssriganesh's avatar
v-ssriganesh
Icon for Community Support rankCommunity Support
10 months ago


Hello RussellBode,
To manually refresh a report in Report Builder, click the Run button to execute the report, you'll see a Refresh button in the toolbar click it to update the data with the latest information.

 


Best regards,
Ganesh Singamshetty.

v-ssriganesh's avatar
v-ssriganesh
Icon for Community Support rankCommunity Support
10 months ago

Hello RussellBode, 

Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

 

Thank you for being part of the Microsoft Fabric Community.