using datasets in reporting services | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

using datasets in reporting services

Is it possible to load a reporting services dataset into a dataset using the report designer? I need to build a report that is going to require me to piece together data from numerous queries and am not sure how to do this without manipulating data programmatically.
put your queries and logic in an object that returns a data set. Then read the dataset using Reporting Services Data Extension. With this aproach you can do any kind of processing you want with you data before it presented in the report. The catch is that you have to implement the data extension yourself. To start up the work see my earlier question "Using a Business Logic Object as Data Source " in this news group. Regs.