Passing a dataset to reporting services

I've seen questions similar to this posted, but I'm unable to find a clear answer to what I need to do.

We are currently using Crystal Reports, generating a dataset in our application and passing it to Crystal. Due to the many problems we have with Crystal we are now looking to move to Reporting Services 2005, but I can't find out how to pass it a dataset.

Although we do use SQL Server for data storage, we have many reports with calculations that are way too complicated to use calculated fields, and which change too often to want to store them in the database. One solution might be to store the data temporarily and regenerate it each time it's required, but this doesn't seem very elegant. So please could someone tell me if there is a way to do what I'm after and point me at a page that gives a nice clear explanation.

Thank you

Hi Williams,

Here's a sample that shows you how to pass a Dataset to SRS.

http://msdn2.microsoft.com/en-us/library/aa902651(SQL.80).aspx

Regards,

Amol.

|||Thanks for that. It's surprisingly hard to find this information by searching.