Does anyone know if you can create a SSRS report, that calls a mainframe Stored Proc? The stored proc runs a complex query against mainframe DB2 tables, and is parm driven....

Hi ajm40241, It seems that you would like to connect to DB2 and use SP in DB2 as a dataset for the report, right? Please correct me if my understanding is wrong. If that’s the case, please refer to the following article: Calling a DB2 SP from Reporting Services: http://blog.hoegaerden.be/2009/04/25/calling-a-db2-sp-from-reporting-services/ For more information about DB2 with Reporting Services, please see the following articles, Reporting On Data From Stored Procedures : http://blog.hoegaerden.be/category/sqlserver/reporting-services-sqlserver/page/2/ Data Sources Supported by Reporting Services (SSRS): http://msdn.microsoft.com/en-us/library/ms159219.aspx If you have any question, please feel free to ask. Thanks, Eileen