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

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'

Answer 1

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

Answer 2

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]

Answer 3

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?

Answer 4

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.

Answer 5

Can you explain the difference between pull & push action?

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

---

Olaf Helper

[ Blog] [ Xing] [ MVP]