report rdl file portability

Hi All:

Just like to know how to import a report ( an RDL file that is created by report design team from VS IDE bundled with SQL Reporting Server 2005) to a report viewer control in a web page (report to be launched in local mode).

The challenge we had is that the dataset, data source objects as configured in the original RDL file cannot be directly taken by the report viewer contrl. We need to use the dataset objects created locally in the web projects for those alien reports. The current process entails meticulous tuning. This will make automation difficult to implement. Is there an easier way to import the report file and integrate it to the web pages

Thank you a lot!

Eugene

Answer this question

report rdl file portability

komminane
Hi Rajeev:

Need to say thank you first for the quick and helpful response!

There is no direct integration of alien reports to web pages indeed. But can I write c# code behind in the web pages to load the RDL file and create the necessary datasource/dataset objects based on the query as configured in original report. In other words can I use c# codes code to implement the tasks that you mentioned:

==========================================
You have to execute the query yourself and supply the resulting DataTable to ReportViewer. Visual Studio can generate the code to do this, but you still have to copy the query out of the RDL and add it to your application.
==========================================

Thank you again,

Eugene
inalein
Hi Rajeev & Jon:

Thank you both. Parsing the xml file is probably the solutin.
Will try it.

Eugene
tetranz
Eugene: Yes, you can do this. As Jon mentioned, since RDL is XML based, you can easily parse it and extract the SQL and execute it. If the query does not have any parameters then this is quite easy. If the query has parameters then this is slightly harder because you have to prompt the user for parameter values (or get the values from somewhere else.)
BeGran
There is no automated way to take an RDL file designed for Report Server and use it in the ReportViewer control in local processing mode.

The RDL file can be supplied to ReportViewer without any modification. (Just rename it to .rdlc and add it to the project.) However, as you mention, ReportViewer will not execute the query contained in the RDL file. You have to execute the query yourself and supply the resulting DataTable to ReportViewer. Visual Studio can generate the code to do this, but you still have to copy the query out of the RDL and add it to your application.

The recommendation is to keep those RDLs on Report Server and point ReportViewer to your server, taking advantage of the remote processing mode of ReportViewer.
cloudstardust
Is there any chance you have a code sample to do this

Thanks,

Paula
cbakopanos
Eugene,

We have a similar delimma in our application. We ended up parsing the RDL file using System.Xml. Wasn't really that difficult to do this and run the query manually, passing a DataTable to the WinForms.ReportViewer.

We find this useful as our reports person is not a developer and he can just check in a new report with a new query and everything doesn't fall apart...

Jon
report rdl file portability

Answer this question