Tuesday, February 18, 2014
header footer mutable report items
To get a value into the header or footer that changes with the data on every page (such as an id number), include the item somewhere in the report body and hide it, then refer to it like =ReportItems!B1_ALT_ID.Value.
Query History
SELECT execquery.last_execution_time AS [Date Time],execution_count, execsql.text AS [Script] FROM sys.dm_exec_query_stats AS execquery
CROSS APPLY sys.dm_exec_sql_text(execquery.sql_handle) AS execsql
ORDER BY execquery.last_execution_time DESC
CROSS APPLY sys.dm_exec_sql_text(execquery.sql_handle) AS execsql
ORDER BY execquery.last_execution_time DESC
Subscribe to:
Posts (Atom)