Open .RDL in ASP.NET without ReportServer

[Chris]

Is it possible to simply add an .RDL to an asp.net project, and access the
report dynamically without any report url or anything.

I just want to pass the database authentication to the .RDL [reportViewer?]
and a few parameters, and run the report. But I do not want the report to
exist in a subweb or http://reportServer etc. I just want to drop it right
into my project, and go.

Thanks for any links or advice.

 

[Bruce L-C [MVP]]

This is totally possible with the new controls that ship with VS 2005. You
can develop the report and then view it in your app using the controls. Note
that this is more work. You have to handle subreports, drill through etc.
Also, I found the design environment in VS 2005 that comes with VS to design
reports nowhere as near as nice as the report designer that comes with SQL
Server. Note that if you have SQL Server, the designer comes with it. You
can develop and preview the reports without deploying them, then just change
the extension and bring them into your project.

 

[Chris]

Thanks for your response. That's good news. I hope MS improves the designer
in VS.
Cant you just design the report using the SQL Server report designer and
then drop the rdl into your web project?

Anyway, thanks again.
BTW: Does anyone have any walkthrough's using this new functionality? I
havent used RS since it first came out.

This is totally possible with the new controls that ship with VS 2005. You
can develop the report and then view it in your app using the controls.
Note that this is more work. You have to handle subreports, drill through
etc. Also, I found the design environment in VS 2005 that comes with VS to
design reports nowhere as near as nice as the report designer that comes
with SQL Server. Note that if you have SQL Server, the designer comes with
it. You can develop and preview the reports without deploying them, then
just change the extension and bring them into your project.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

Is it possible to simply add an .RDL to an asp.net project, and access
the report dynamically without any report url or anything.

I just want to pass the database authentication to the .RDL
[reportViewer?] and a few parameters, and run the report. But I do not
want the report to exist in a subweb or http://reportServer etc. I just
want to drop it right into my project, and go.

Thanks for any links or advice.

 

[Bruce L-C [MVP]]

You can use the SQL Server report designer and then rename the extension and
then use that. That is really the easiest. The issue with VS is that there
is no preview. You have to deploy and use either your web page or your
winform to view the report.

Just dropping the rdl into your web project makes no sense unless there is
something to render the report. That is where the new controls come in.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

Thanks for your response. That's good news. I hope MS improves the
designer in VS.
Cant you just design the report using the SQL Server report designer and
then drop the rdl into your web project?

Anyway, thanks again.
BTW: Does anyone have any walkthrough's using this new functionality? I
havent used RS since it first came out.

This is totally possible with the new controls that ship with VS 2005.
You can develop the report and then view it in your app using the
controls. Note that this is more work. You have to handle subreports,
drill through etc. Also, I found the design environment in VS 2005 that
comes with VS to design reports nowhere as near as nice as the report
designer that comes with SQL Server. Note that if you have SQL Server,
the designer comes with it. You can develop and preview the reports
without deploying them, then just change the extension and bring them
into your project.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

Is it possible to simply add an .RDL to an asp.net project, and access
the report dynamically without any report url or anything.

I just want to pass the database authentication to the .RDL
[reportViewer?] and a few parameters, and run the report. But I do not
want the report to exist in a subweb or http://reportServer etc. I just
want to drop it right into my project, and go.

Thanks for any links or advice.