HI, My question is as follows, I have a Data set in my project code and need to make use of this in ssrs directly,i mean this data set is not accesible by the ssrs directly by accessing the database from which the data set has been build. The ssrs will be only able to access the data set from the c# code in my visual studio but will not be able to acess the db from which this data set has been built by the c# code in my visual studio i know we can go to ssrs and create the data set that we need by making use of the query and make use of this data set.Also we can add existing items.

You can build a .net web application and add build an SSRS report within application (rdlc file on local mode) that uses the dataset you are building with .net c# code. Then using the reportviewer control on local mode, you can display the report that consumes your dataset. When done this way, you need not worry if the report dataset is not directly accessible by SSRS or not. Please refer the below link for further details and samples http://www.codeproject.com/KB/reporting-services/RDLC_and_DataSet.aspx http://am22tech.com/s/22/Blogs/post/2010/05/03/Designing-and-developing-RDLC-reports-in-aspnet-using-ReportViewer-and-Datasets.aspx Hope this helps. Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH