What is difference between .rdl and .rdlc files?

Question

What is the difference between .rdl and .rdlc files?

Puneet Kankar · Answer

RDL means Report Definition Language. RDLC refers to Report Definition Language Client Side. RDL developed by SQL Server 2005 Report Viewer. RDLC created by Visual studio. RDL deals with items on the server end. RDLC deals with issues on the client side. RDL specifically requires all elements to come with values. RDLC does not strictly need to have all elements in values. RDL takes little time to produce large data sets due to the use of server license. An RDLC run on a local license hence takes more time to give an output of a large data set.

Jyoti Jodha · Answer

What is the difference? RDL files are created by the SQL Server 2005 version of Report Designer. RDLC files are created by the Visual Studio 2005 version of Report Designer. RDL and RDLC formats have the same XML schema. However in RDLC files some values (such as query text) are allowed to be empty which means that they are not immediately ready to be published to a Report Server. The missing values can be entered by opening the RDLC file using the SQL Server 2005 version of Report Designer. (You have to rename .rdlc to .rdl first.) RDL files are fully compatible with the ReportViewer control runtime. However RDL files do not contain some information that the design-time of the ReportViewer control depends on for automatically generating data-binding code. By manually binding data RDL files can be used in the ReportViewer control. Note that the ReportViewer control does not contain any logic for connecting to databases or executing queries. By separating out such logic the ReportViewer has been made compatible with all data sources including non-database data sources. However this means that when an RDL file is used by the ReportViewer control the SQL related information in the RDL file is simply ignored by the control. It is the host application's responsibility to connect to databases execute queries and supply data to the ReportViewer control in the form of ADO.NET DataTables. http://www.differencebetween.net/technology/difference-between-rdl-and-rdlc/