Can I use a published report as a datasource for other reports?

Hi,

I have a data table called STOCKPE which holds stock valuation information at the close of business each day. I wish to use reporting services to extract the data in this table on a daily basis and keep a daily history on the report server. I know I can do this - this isn't my problem.

When I have the history of this table on the report server, can the data that the reports on the report server hold be used as a datasource for another report?

I'm no expert in reporting services, so if this is possible, or if there's a better way of doing it, please use small words and short sentences. No offence intended to all the very well educated SQLRS wizards out there, it's just that I'm not one of them and your answer will be lost on me if you use a lot of abreviations and acronyms.

Thanks,

Chris

Hi,

I guess you are takling about Snaphots in SQL Server RS. Snapshots are dedicted to one Report (actually its a snapshot of the report). AFAIK there is no way to base reports on other reports snapshot data.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi Jens,

I had a feeling this was the case but y'never know so I thought I'd ask all the same.

Thanks for your response, much appreciated.

Chris