Reporting Server Rendering

Hi Everyone,

Let me first tell u guys/gals what i hve done till now. I've created a Report Server and created a TestReport.rdl file in it. This report is bound to a DataSet. Now i want to ask few qusetions:

First, Is it possible to call this report from another Project (Web) so that it could be rendered directly to ReportViewer without having to specify a DataSource ? I mean, i wouldn't have to specify the ReportDataSource again since it's already specified when i created that report.

Second, can the same functionality be specified for .rdlc (client file) ?

Till now i've worked out this code:

<code>

rptView.ProcessingMode =ProcessingMode.Remote;

rptView.ServerReport.ReportServerUrl =newUri("http://localhost/Tutorial/");

rptView.ServerReport.ReportPath ="Report2";

</code>

but this doesn't seem to work and keeps on giving me this error:

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.The request failed with HTTP status 404: Not Found.

Any points in the right direction will be greatly appreciated. TIA

ok i figured out part of the problem, it was happening because Report Server wasn't configured properly. But now it says "Report requires an Active Database Connection" but when i try to configure the database through Reporting Service Manager i get the error:

Using Other editions of SQL Server for report Data Source and/or the reprot Server Database is not supported.

not sure wat that means but i'm lookng into it.

Any help will b appreciated. TIA