Search

New "built-in Fields" to display IF and When a Report-Cache was used by JJ78

Active

1
0
Sign in
 to vote
Type: Suggestion
ID: 766715
Opened: 10/9/2012 6:42:47 AM
Access Restriction: Public
0
Workaround(s)
SSRS Report and Dataset Caching is a greate feature to optimize effective Enduser-Responsetime of reports. But for the end user it might be absolut relevant to understand if the data in report is "live" or comes from SSRS caching.

The needed information is existent in ReportServer-Database (ExecutionLog-Table). But its not easy for the ssrs developer to correlate and use this data to be displayed in the enduser-report session.
Details (expand)

Product Language

English

Category

Reporting Services

Proposed Solution

My suggestion would be to add 2 additional built-in fields which can be used in expressions:

Caching.IsRenderedFromCache = 1/0, display if data is live or from "ReportserverTempDB"
Caching.CacheCreateDateTime = "CreatedDate"-colum from table dbo.Snapshotdata

Primary Benefit

Improved User Interface

Other Benefits

 

Virtualization

 
File Attachments
0 attachments
Sign in to post a comment.
Sign in to post a workaround.
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement