none
What's the best method to refresh a report when the field is updated in SQL? RRS feed

  • Question

  • I'm aware that there is an AutoRefresh property that you can set to X amount of seconds that you want the report to refresh. I want when a field fbin1 is changed I want the report to refresh. The purpose is the report to displayed on a large screen in a factory so when a worker makes a change they'll be able to see the refresh happen.

    Would this be best achieved in SSRS or in SQL with a trigger or stored procedure?

    Select fpartno, flocate1, fbin1 from inmastx 
    Where fprodcl='02'

    Wednesday, March 13, 2019 4:57 PM

All replies

  • the Report is normaly working with a pull Action, 

    you Looking for a Push Action what is not yet Ready, for this you Need a Event Trigger to say "if the value Change refresh the Report". you can use the Auto Refresh that is all. 


    Klaus

    Wednesday, March 13, 2019 5:00 PM
  • Would this be best achieved in SSRS or in SQL with a trigger or stored procedure?


    Neither nor; it's simply not possible. SSRS is a reporting system to present & print data, not a real time display app.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Wednesday, March 13, 2019 6:29 PM
  • the Report is normaly working with a pull Action, 

    you Looking for a Push Action what is not yet Ready, for this you Need a Event Trigger to say "if the value Change refresh the Report". you can use the Auto Refresh that is all. 


    Klaus


    Can you explain the difference between pull & push action?
    Wednesday, March 13, 2019 7:08 PM
  • Hi David9501

    According to your description ,seems you want to refresh the report when the data in the particular column changed ,right ?

    Seems it was the event driven schedule , for ssrs ,seems there is not built-in function or feature to support the auto-fresh driven by event.

    While you could try to export the report as subscription via the event driven using the sql-rd (a third-part software about ssrs schedule).

    See:

    SQL-RD | Event Driven Schedules | Schedule SSRS Reports based on Database Triggers

    Hope it can help you.

    Best Regards,

    Eric Liu


    Best Regards, Eric Liu MSDN Community Support Please remember to click Mark as Answer if the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread.

    Thursday, March 14, 2019 3:11 AM

  • Can you explain the difference between pull & push action?

    See https://simplicable.com/new/pull-vs-push-technology

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Thursday, March 14, 2019 11:31 AM