报表历史记录是随着时间变化而创建的报表快照的集合。 您可以按需创建报表历史记录,也可以安排快照的创建频率以及将快照添加到报表历史记录中的频率。 报表历史记录存储在报表服务器数据库中。 如果报表快照中包含大量数据,则可考虑限制报表历史记录,尽可能地减少快照保持期对数据库大小的影响。
日志字段 (ExecutionLog)下面的示例是一个 Transact SQL 语句,从视图 ExecutionLog 检索行。 该示例假定报表服务器数据库名为 ReportServer:Transact-SQL 复制 Use ReportServer select * from ExecutionLog order by TimeStart DESC 下表描述了在报表执行日志中捕获的数据。
記錄欄位 (ExecutionLog) 下面的範例是可從 ExecutionLog 檢視中擷取資料列的 Transact SQL 陳述式。 此範例會假設報表伺服器資料庫名為ReportServer: tsql複製 Use ReportServer select * from ExecutionLog order by TimeStart DESC 下表描述在報表執行記錄中擷取的資料。
Find Text, Numbers, or Dates in a Report Configure Execution Properties for a Report Limit Report History Upload a File or Report Create a Linked Report Export Reports Print Reports Report data in SSRS SQL Server mobile reports Reporting Services Security and Protection ...
Configure report execution properties, report history, and report parameters. Create shared schedules and shared data sources to make schedules and data source connections more manageable. Create data-driven subscriptions that role out reports to a large recipient list. Create linked reports to reuse an...
The amount of data collected in the ExecutionLog table will grow steadily on a busy server. In order to conserve space you will want to retain only a small amount of history. However, you would like to be able to go back and see over time how report usage patterns are changing....
Find the Report Definition Schema Version Find Text, Numbers, or Dates in a Report Configure Execution Properties for a Report Configure General Properties for a Report Limit Report History Open and Close a Report View or Delete Report History Upload a File or Report Create a L...
A URL request enables you to access a specific report server and the reports, resources, and other items in the report server database. You can also customize the report viewing and navigation experience for your users. The query string of the URL contains device informa...
Report snapshots (which include query results) and report history. System properties and system-level security settings. Report execution log data. Symmetric keys and encrypted connection and credentials for report data sources. Because the report server database stores application state and persistent da...
“Store all report execution snapshots in history” will show the automatically generated snapshots in the history in addition to the scheduled snapshots. “Use the following schedule to add snapshots to report history” will create snapshots per your schedule and add them to the history. ...