Data Source for Reporting Services
-
hi, i am very new to the MS SQL Server 2000 Reporting Services. i have made a few reports, and in each case made a dataset from the Report Designer view in VS.NET 2003. now my question is that how am i suppose to provide the datasource through code at runtime? is it possible in Reporting Services as was in the case of Crystal Reports? and if there is a way, what is it? can anyone guide me through the procedure? thanx in advance ☺«««DTA»»»☺
-
hi, i am very new to the MS SQL Server 2000 Reporting Services. i have made a few reports, and in each case made a dataset from the Report Designer view in VS.NET 2003. now my question is that how am i suppose to provide the datasource through code at runtime? is it possible in Reporting Services as was in the case of Crystal Reports? and if there is a way, what is it? can anyone guide me through the procedure? thanx in advance ☺«««DTA»»»☺
you can use SP with parameters as queries in the RDL and your SP may return a record set that depends on parameters you pass to. you can pass those parameters to the msrs report thru ReportingService.Render() webmethod. check the followin http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp\_ref\_soapapi\_service\_ak\_1xfd.asp\[^\] http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp\_ref\_soapapi\_service\_lz\_49f6.asp\[^\] http://www32.brinkster.com/srisamp/sqlArticles/article\_41.htm\[^\] probaly you work on a huge project that has many many sps and some of them use temporary tables or returns multiple recordset then you are not able to use those sps in the msrs because as a rule those sps does not have a predifined data scheme. may be you applcation has eiter many webservices or data access components that provied data that could be shown in reports then maybe it makes sense to make an extension to the msrs that is tied with your application. so that you can reuse existing code that retrives data from the db. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp\_ref\_clr\_dataproc\_8p85.asp\[^\] it looks like it's easy to make
-
you can use SP with parameters as queries in the RDL and your SP may return a record set that depends on parameters you pass to. you can pass those parameters to the msrs report thru ReportingService.Render() webmethod. check the followin http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp\_ref\_soapapi\_service\_ak\_1xfd.asp\[^\] http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp\_ref\_soapapi\_service\_lz\_49f6.asp\[^\] http://www32.brinkster.com/srisamp/sqlArticles/article\_41.htm\[^\] probaly you work on a huge project that has many many sps and some of them use temporary tables or returns multiple recordset then you are not able to use those sps in the msrs because as a rule those sps does not have a predifined data scheme. may be you applcation has eiter many webservices or data access components that provied data that could be shown in reports then maybe it makes sense to make an extension to the msrs that is tied with your application. so that you can reuse existing code that retrives data from the db. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp\_ref\_clr\_dataproc\_8p85.asp\[^\] it looks like it's easy to make