Score:-1

Are the results from Microsoft SSRS in real-time from SQL Server?

in flag

From my understanding MS SSRS is a data warehouse product. Its data is only as new as the last refresh. However, 3rd party support insists that SSRS results are in real-time.

If I am using a SQL Server view as a data source, are the SSRS results in real-time (ie whenever someone reads a SSRS report, it pulls it from SQL Server); or is it stored within SSRS and only updated with a refresh?

Jaromanda X avatar
ru flag
it is, as you call it, "real time" - i.e. you execute the report, it uses the current data from the database - perhaps you're conflating the fact that SSRS reports themselves (i.e. the layout etc) are stored "within SSRS" as you put it.
chaostheory avatar
in flag
@JaromandaX See the answer from Ben Thul. There are more options for querying data than just always hitting SQL Server directly. If you were always immediately querying SQL Server, it would defeat the entire purpose of having a data warehouse.
Jaromanda X avatar
ru flag
well that's why I made it a comment not an answer :D
Score:1
cn flag

There are options on how to run the report. Doing a copy/paste summary from the docs to here for posterity:

  • On demand - You can specify that a report query a data source each time a user runs the report.
  • On demand from cache - With this approach, if ten users open the report, only the first request results in report processing. The report is subsequently cached, and the remaining nine users view the cached report.
  • From snapshots - A report snapshot is a report that contains layout information and data that is retrieved at a specific point in time.

So you may be right but third party support may also be right! You'll need to look at the properties of the relevant reports in SSRS to see how they're configured.

I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.