ASP.Net SQL Server Reports

Hi All

I want to utilize (embed) sql reporting service report in my ASP.Net web page. i.e., I want to handle all connections to sql server etc., from the ASP.Net page itself.. I have seen lot of examples which deal with SQL reporting services directly using viewers and hosting the report on IIS etc.,

Please give some idea on how to do the task

Any kind of help would be gr8ly helpful

SQLRS is available as a web service. You can always call the webservice and pass the parameters and retrieve the report. There's plenty of articles availableif you google.

ASP.NET 2.0 and SQL Reporting Services

I am running SQL Server 2000 and would like to utilize the SQL Server Reporting services I have heard so much about. How can I do this in Visual Studio 2005? If you install the 2000 Reporting Services it says the Report Designer requires 2003 of VS. I would like to use it in 2005 though. Anyone do this? I can't imagine I am the only one. ;)Yes, I'm having the same need. I'm using the VS 2005 Beta2.|||

You can add RS reports to an existing project; Select "Add New Item" to the project then select "Report" they now have a file ext of RDLC.
btw, it is only available on VS 2005 Developer and up, read more...http://www.microsoft.com/technet/prodtechnol/sql/2005/2005ssrs.mspx