Compare historical reporst
Is there a way to compare a report from the history to another one? I'd like to run a report once a month and compare it's output to the month before.
October 29th, 2010 7:57am
You can create snapshots of the report based on a monthly schedule and manually compare the current report to the snapshots. Is this kind of what you are looking for?
October 29th, 2010 2:08pm
I read that when saving a snapshot it saves the dataset + the report design. I'd like to compare the dataset from one month to another. Is there a way to query the dataset the snapshot saves?
October 30th, 2010 4:18pm
You need to add a summary page to your report to show running totals, for example for the last three months. Alternatively, use T-SQL with full outer join to compare results for two consecutive months based on primary key. Add an audit table and log monthly results there for future comparison. Sergei
October 31st, 2010 2:06am
I'm asking if there is a way to use the recordsets of the snapshot for that T-SQL comparation
October 31st, 2010 3:40pm
I am not sure but you can try EXISTS http://msdn.microsoft.com/en-us/library/ms188336.aspx Gaurav Gupta http://sqlservermsbiblog.blogspot.com/
October 31st, 2010 5:35pm
Not done any work on it but the data should exist in the 'Segment' / 'SegmentedChunks' / 'Chunkdata' tables in the reportserver with links back to teh history via the SnapshotID Whether you can query that chunkdata in any meaningful way I am not sure - I did find this example query: select ReportID, AbsoluteExpiration, SnapshotDataID from ReportServerTempDB.dbo.ExecutionCache select SnapshotDataID, CreatedDate, ExpirationDate from ReportServerTempDB.dbo.SnapshotData select SnapshotDataID, ChunkName, ChunkType from ReportServerTempDB.dbo.ChunkData From http://www.mssqltips.com/tip.asp?tip=1919 But I would imagine that you would need to use VB.NET / C# to actually parse the data held in the chunk tableRgds Geoff
October 31st, 2010 7:16pm