Real time reporting in SSRS

Question

All,

We've got a requirement to build the real time report. user can browse report at any point of time and need to see the latest data(stock market) in the report.

What would be the best approach to build real time report.

I've few options down...

1. Directly point to OLTP database as source and write stored procedure to show result set.

2. Replicate the database and write the SP's to reports. To avoid pointing directly to OLTP db.

3. To build the datawarehouse with dim & facts to show it in reports. I prefer this as a standard method, but this would have some latency depending on trasaction load which will differ from the requirement.

Thank you

Answer 1

Hi msbi-msbi,

According to your description, you want to create a report to display most recent data, right?

In Reporting Services, if we want to display most recent data in a report, we could specify the processing option as "Always run this report with the most recent data". For more information, please refer to this article: Processing Options Properties Page (Report Manager).

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu

---

Qiuyun Yu
TechNet Community Support

Answer 2

You actually need SignalR and you need to do reporting in ASP.NET. AFAIK, there is no real time reporting feature available in SSRS. With SignalR you can easily develop stock market report and whenever you update your database it will reflected on your report. You just have to enable SQL dependency.

I had developed a signalrr project for the same, I lost the code now but I am sure online forums and blogs can provide you complete insight about it.

https://www.youtube.com/watch?v=Ox9VueMdRyo

---

Glad to help! Please remember to accept the answer if you found it helpful. It will be useful for future readers having same issue.


My Profile on Microsoft ASP.NET