Visual Studio .NET - Converting RDL(Sql Reporting Services) into RDLC(.NEt)

Asked By vamsi n on 16-Jul-08 08:33 AM

Hi All

i have a RDL in Sql Reporting Services, now have to convert the RDL into RDLC of Asp.Net

what are the steps i have to follow

pls help me

thanking you

Rghavendra

See this - Sagar P replied to vamsi n on 16-Jul-08 09:38 AM

Only SQL Server 2005 RDL files can be converted to RDLC files. If you have RDL files from a previous version, you must upgrade them to SQL Server 2005 before migrating them to the .rdlc file format. To upgrade a report definition, open it in the SQL Server 2005 version of Report Designer.

Converting a report definition of either file type requires that you re-create data source and query information. Be sure to choose a data source schema that is the same as or structurally identical to the one used in the original report. If the schema is different, the report layout might not be valid for the data source you want to use. If you want to use different data sources, it is easier to re-create the report from the beginning rather than convert it.

RDL-to-RDLC Conversion

When converting a .rdl file to .rdlc format, you must manually replace the data source and query information in the report definition with data constructs provided in your application.

  1. Rename the .rdl file to use the .rdlc file extension.

  2. In Visual Studio 2008, open the solution or project that will contain the report.

  3. Create or add the dataset that defines the data you want to use to your projector solution. For more information, see http://msdn.microsoft.com/en-us/library/ms252094.aspx.

  4. On the Project menu, click Add Existing Item and then select the .rdlc file that you created in the first step.

  5. In the project, open the form or Web page that will contain the report.

  6. From the Toolbox, in the Data group, drag a ReportViewer control onto the form or Web page.

  7. In the ReportViewer Tasks smart tags panel, in Choose Reports, select the .rdlc file to use with the control.

  8. In the ReportViewer Tasks smart tags panel, in Choose Data Sources, select the dataset you want to use. The dataset object, binding source object, and table object will appear at the bottom of the workspace. For more information about updating data source references, see http://msdn.microsoft.com/en-us/library/ms252085.aspx.

  9. Save all files, and then build or deploy the project to verify that the report contains the data you expect.

Go thr this link for more details;

http://msdn.microsoft.com/en-us/library/ms252109.aspx

Best Luck!!!!!!!!!!!!!!
Sujit.

Solution Converting RDL(Sql Reporting Services) into RDLC(.NEt) - Sakshi a replied to vamsi n on 16-Jul-08 11:16 AM

you can simply convert the .rdl file to rdlc by renaming the .rdl to .rdlc

Reply - alice johnson replied to vamsi n on 16-Jul-08 12:53 PM

If the RDL file is from 2000 then you need to open and convert it to RS 2005
RDL format. Then rename the file from RDL to RDLC.
rdl to rdlc - sundar k replied to vamsi n on 16-Jul-08 01:27 PM

Reports that you create in SQL Server 2005 Reporting Services (saved as .rdl files) can be converted to the client report definition (.rdlc) file format used by the ReportViewer controls. This is called an RDL-to-RDLC conversion.

Reports that you create for ReportViewer controls (saved as .rdlc files) can be converted to the report definition (.rdl) file format used in SQL Server Reporting Services. This is called an RDLC-to-RDL conversion.

You can check out the below msdn link for how its done!

Converting RDL and RDLC Files 

http://msdn.microsoft.com/en-us/library/ms252109(VS.80).aspx

Check this - This may help - santhosh kumar replied to vamsi n on 17-Jul-08 04:01 AM
    I was originally creating reports for the web application using Visual Studio 2005 and creating RDLC files. I am using RDLC files because we do not have SQL 2005 with Reporting Services installed anywhere, so we are currently unable to host the new reports on a Report Server. I found that after I installed SQL Server Express 2005 with Advance Features, and selected install client templates (or something like that) I had a new project type in Visual Studio for a Business Intelligence project. After some messing around I found that you can use the advanced features of the Business Intelligence studio to create your reports, but that you can easily convert them to the RDLC files that the report viewer control for ASP.NET looks for.

To do this all you have to do is create a new Business Intelligence Project in VS and either use the wizard to create the reports or create them manually. I’ve been using the wizard, as it cuts development time from a couple hours to a couple minutes. Once you have your report created you can save the file, locate the file on disk and rename it with the RDLC extension.

Next add existing item to your web application. Once you have the new RDLC file in your web application, create a dataset in your App_Code folder using the EXACT same SQL statement(s) that you used in the Business Intelligence Project. Open the RDLC file and rebind both the report data source as well as the datasource for any tables in the report to your new dataset.

Add a .aspx page to the application and drop a report viewer control on the page. Point the control at your RDLC and rebind the data sources. Once complete you will have your report which was originally designed for Report Server, available as a client report that ASP.NET pages will happily display.
Converting RDL(Sql Reporting Services) into RDLC(.NEt) - Ganesh Shivshankar replied to vamsi n on 23-Apr-09 03:21 AM

As mentioned, just rename the rdl file to rdlc.

All you would need to do now is obtain the CommandText from the rdlc xml, fire it against your database with the appropriate parameters (if any), create a report datasource and add it to your report with the same name as the datasource specified in the rdlc and just refresh your report.

It'll work like a charm !

Pieter replied to vamsi n on 14-Mar-10 05:34 AM
Only reports that are generated in SQL Server 2005 and higher can be converted to a rdlc file, if your running a release that predates the 2005 SSRS release open it up in report designer 2005 or 2008 to convert it to a 2005 or 2008 report.

There are a few manual steps to complete inside your asp.net project and checks on the rdl datasources and queries, those are explained here :

http://msdn.microsoft.com/en-us/library/ms252109%28VS.80%29.aspx

Hope it helps,
Pieter
Customer Support replied to vamsi n on 13-Apr-10 10:01 PM
Converting RDL files to RDLC files can be very tricky.  This is why the http://www.rdlreportviewer.com was created to do this automatically so there is no need for Reporting Services.  The http://www.rdlreportviewer.com control is able to view RDL Reports and show http://www.rdlreportviewer.com/featureautomaticparameters.aspx, http://www.rdlreportviewer.com/featuredrillthrough.aspx, etc. and the developer only needs to set the report name.  Its that easy.  The RDLReportViewer uses the Microsoft ReportViewer control so you have the security of having all your reports show up right.  Click http://www.rdlrerportviewer.com to check it out...