Importing report content direct to SQL Server for testing purposes

Hi

I have what seems a simple requirement. We want to import the contents of a SQL Server 2005 Reporting Services report into a SQL Server 2005 database, in order to perform some checks on reports displayed to users. Is there an easy way to achieve this? XML would seem appropriate, but I can't find a step-by-step guide on how to achieve this. Any pointers/suggestions would be appreciated.

Thanks

Neil

Hey Neil,

If you export the report to CSV, it should be fairly easy to import that data back into your database using Integration Services.

Jarret

|||

Hi Jarret

Thanks for the CSV idea. However the reports are fairly complex, with a number of totals, sub-reports, etc, that would be difficult to make sense of with CSV. I guess that XML would enable the meaning of each value to be specified along with the value, and hence loaded more easily for subsequent checking. However, since I simply wanted to integrate two Microsoft products I was hoping there was an easy way to capture Reporting Services output and import into SQL Server. Could well be that I'm missing something obvious though - hence my request!

Thanks

Neil

|||

We have found a workable solution.

Create report subscriptions in Reporting Services to export the report content as XML.sql