none
~* Difference between RDL and RDLC *~

    Question

  • hi,

    i am confused with RDL and RDLC.  when to use RDL and RDLC..

    can anyone help me out of this.

    Thanks in advance.

     

    Tuesday, May 16, 2006 9:44 AM

Answers

  • Why don't give google a try ;)
    http://www.google.de/search?q=rdl+rdlc

    1. Q: What is the difference between RDL and RDLC formats?

      A: 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.


    Tuesday, May 16, 2006 12:18 PM
  • Yes, the VS 2010 release will include updated report viewer controls with an RDLC version that is equivalent to the RDL 2008 schema used in RS 2008 today.

    Thanks,
    Robert
    Robert Bruckner; http://blogs.msdn.com/robertbruckner; This posting is provided "AS IS" with no warranties, and confers no rights.
    Wednesday, January 07, 2009 4:51 PM
    Owner
  • Not sure what you are asking for. Editions of VS 2005 which include the ReportViewer controls (www.gotreportviewer.com), include an integrated report designer to design reports for the "local mode".

    If you want the full BI Development Studio, you could download the SQL Server Express Toolkit (http://www.microsoft.com/downloads/details.aspx?familyid=3c856b93-369f-4c6f-9357-c35384179543&displaylang=en), or buy the SQL Server 2005 Developer Edition.

    -- Robert

    Friday, May 19, 2006 4:25 AM
    Owner
  • Well, if you use RDL and Reporting Services, you actually get a report server that allows to manage users, permissions, data sources etc. in one place.  Furthermore, you get report models, report builder.  You can have reports delivered via subscriptions for example as emails, etc.

    The following link provides a quick overview of Reporting Services functionality in RS 2005: http://msdn.microsoft.com/en-us/library/ms159273(SQL.90).aspx

    RS 2008 has many additional features (see this posting for a summary overview) that are not yet available for local mode reports (i.e. RDLC).

    Thanks,
    Robert
    Robert Bruckner; http://blogs.msdn.com/robertbruckner; This posting is provided "AS IS" with no warranties, and confers no rights.
    Monday, January 05, 2009 5:38 PM
    Owner
  •   The following article describes how to build a custom data processing extension for Reporting Services that enables you to use an ADO.NET DataSet as a data source: http://msdn.microsoft.com/en-us/library/aa902651(SQL.80).aspx

    Thanks,
    Robert
    Robert Bruckner; http://blogs.msdn.com/robertbruckner; This posting is provided "AS IS" with no warranties, and confers no rights.
    Wednesday, January 07, 2009 5:35 AM
    Owner

All replies

  • Why don't give google a try ;)
    http://www.google.de/search?q=rdl+rdlc

    1. Q: What is the difference between RDL and RDLC formats?

      A: 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.


    Tuesday, May 16, 2006 12:18 PM
  • Thanks BenniG.

    is there any Report Designer for Visual Studio 2003 version?

    Wednesday, May 17, 2006 1:42 AM
  • Report designer for Reporting Services 2000 will install into an existing installation of Visual Studio 2003.

    Report designer for Reporting Services 2005 installs as part of BI Development Studio (SQL Server Client Tools).

    -- Robert

    Wednesday, May 17, 2006 3:49 PM
    Owner
  • Robert,

     

    Is it possible to get Report Designer for VS2005 Team Developer WITHOUT purchasing Report Server 2005 which includes BI Development?

     

    Jim

    Thursday, May 18, 2006 7:30 PM
  • Not sure what you are asking for. Editions of VS 2005 which include the ReportViewer controls (www.gotreportviewer.com), include an integrated report designer to design reports for the "local mode".

    If you want the full BI Development Studio, you could download the SQL Server Express Toolkit (http://www.microsoft.com/downloads/details.aspx?familyid=3c856b93-369f-4c6f-9357-c35384179543&displaylang=en), or buy the SQL Server 2005 Developer Edition.

    -- Robert

    Friday, May 19, 2006 4:25 AM
    Owner
  • We are confused whether if we use RDL files or RDLC files...in VS2005
    if we use RDLC file we dont have to  buy liecence for reporting services...but we can't export to other formats like MHTML,CSV etc
    if we use RDL files what other benefit we will get...?
    Monday, January 05, 2009 1:42 PM
  • Well, if you use RDL and Reporting Services, you actually get a report server that allows to manage users, permissions, data sources etc. in one place.  Furthermore, you get report models, report builder.  You can have reports delivered via subscriptions for example as emails, etc.

    The following link provides a quick overview of Reporting Services functionality in RS 2005: http://msdn.microsoft.com/en-us/library/ms159273(SQL.90).aspx

    RS 2008 has many additional features (see this posting for a summary overview) that are not yet available for local mode reports (i.e. RDLC).

    Thanks,
    Robert
    Robert Bruckner; http://blogs.msdn.com/robertbruckner; This posting is provided "AS IS" with no warranties, and confers no rights.
    Monday, January 05, 2009 5:38 PM
    Owner
  •  thank you Robert for your quick response...

    But the problem with SSRS BI Studio report viewer is that it doesnt allow to attech ADO.NET dataset
    in Remote (or Server) Processing mode
    . (only in Local mode)
    And we had data involving many Business Logic manipulation which only be done via .NET code.

    Now there are some solutions avaiable to send data to a server report dataset.
    Custom Data Extensions
    http://www.devx.com/dbzone/Article/31336
    XML Web Service for data supply
    But then implementation efforts for these are high...also they do not seem to be smooth implementation
    (may cause performance issues).
    It there any other way we can bind data to RDL file from .NET code.




    we wish to have below architecture(with default features of subscriptions email etc.)
    Reportserver--->Reports(.rdl)       <-----Data from SQL SERVER 
                                      ^            
                                       |
                                       |                                
                                  .NET DATASET (complex and manipulated data)



    otherwise we will have--->
              Webserver---->Application + Reports (.rdlc)       <-----data from dataset
                                                     |
                                                     |
                                      Custom SchedulingServiceApplication for report emailing--.Emails

     
    what is good according to you?
    N.B. We have no problem buying SSRS Standard liecence for our webapplication but it should have feature to attech dataset from .net in case some complex processing required.
                                                                         

        




     





    Tuesday, January 06, 2009 6:39 AM
  • ALSO...If  we want to use RDL and RDLC files togather....
    But while viewing the reportviewer sometimes user will see many Export format and sometimes only Pdf and xls that will be ambiguos to user...is there any solution to it...
    Can u please tell me a link for Custom Data Extension feature....?

    RDL file--->.NET code providing data



    PLZ ASAP as the project has been signed off.... :)

    Wednesday, January 07, 2009 5:32 AM
  •   The following article describes how to build a custom data processing extension for Reporting Services that enables you to use an ADO.NET DataSet as a data source: http://msdn.microsoft.com/en-us/library/aa902651(SQL.80).aspx

    Thanks,
    Robert
    Robert Bruckner; http://blogs.msdn.com/robertbruckner; This posting is provided "AS IS" with no warranties, and confers no rights.
    Wednesday, January 07, 2009 5:35 AM
    Owner
  •   thank you rebort for your quick response....
    you are saving the day here for us ....
    We have decided to go with RDLC (free one) as it provides almost all the functionality we needed...
    also we have a design for Custom Emailing and Subcription service application, and our user base just views the report they will never have to design any report.


    As far as I know the only limitation will be custom controls (III party) can not be used with RDLC.
    and only two export features XLS and PDF. I hope our Customer will be happy with it...


    Will future RDLC versions advance as RDLs in terms of functionality?
    As now we are going to write .NET code for all the RDLC later if there is some imbalance in RDL and RDLC...migration of DOT NET code to ReportDataSets will be difficult.
    Wednesday, January 07, 2009 6:31 AM
  • Yes, the VS 2010 release will include updated report viewer controls with an RDLC version that is equivalent to the RDL 2008 schema used in RS 2008 today.

    Thanks,
    Robert
    Robert Bruckner; http://blogs.msdn.com/robertbruckner; This posting is provided "AS IS" with no warranties, and confers no rights.
    Wednesday, January 07, 2009 4:51 PM
    Owner
  •  http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/913e24c3-39f9-4d81-8d80-6af8adf56a3e/

    This is what I was talking…RDLC has the WEB FARMING CAPABILITIES WITH OUT PROCURING LIECENCES.
    1. As we all know that SSRS will take a license of SQL Server if the web service is deployed on any other machine other than SQL Server (which is normally the case because no serious DBA will allow IIS apps to be installed on the DB Server). Also, if the SSRS is deployed on NLB cluster then each node of the cluster would need a "SQL Enterprise" license. (which can be very expensive).
    2. Co deploying the SSRS with SQL Server is a bad idea because it puts excessive load on the DB+Report Server.
    3. Since there is no "load balancing" in SQL all the rendering has to be done by the SSRS service which is running on the DB Server.
    Now compare this to RDLC
    1. RDLC gives me the same engine as RDL
    2. However it has no licensing tags to it.
    3. I can deploy ASP.NET report viewer on my web farm and scale it out as much as I like
    4. Extract data from the DB using stored procedures.




    explains more about the RDLC benefits....in case emailing, security etc are customly made for an application and users use CANNED reports. (static reports.)

    Thank u.
    I hope we close the discussion...
    • Proposed as answer by abhisharma Thursday, January 08, 2009 11:08 AM
    Thursday, January 08, 2009 11:08 AM
  • we started using RDL with CDE and now XML blasts if > 4MB.

    Dataset-->XML-->CDE-->if greater than 4MB 

    EXCEPTION: System.Web.HttpException: Maximum request length exceeded


    FULL ERROR:

    System.Web.Services.Protocols.SoapException:
    There was an exception running the extensions specified in the config file.
    ---> System.Web.HttpException: Maximum request length exceeded.

       at System.Web.HttpRequest.GetEntireRawContent()
       at System.Web.HttpRequest.get_InputStream()
       at System.Web.Services.Protocols.SoapServerProtocol.Initialize()
       --- End of inner exception stack trace ---
       at System.Web.Services.Protocols.SoapServerProtocol.Initialize()
       at System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type, HttpContext context,   HttpRequest request, HttpResponse response, Boolean& abortProcessing)

       at Microsoft.Reporting.WebForms.ServerReport.SetParameters(IEnumerable`1 parameters)
       at ReportViewVUPrintFile.Page_Load(Object sender, EventArgs e) 
       in c:\TIS\Fleetservices\TIS-Web3.0\UILayer\ReportViewVUPrintFile.aspx.cs:line 114
     
       =iif(cint(Parameters!bSpecificCondition.Value) = 1,False,True)

    Wednesday, February 18, 2009 7:45 AM
  • I don't know about your implementation of the custom data extension, but if you are trying to upload xml files, by default there is a 4 MB file limit in ASP.NET.

    This limit is determined by the maxRequestLength attribute that exists under httpRequest in the Machine.config file. You can change these settings either in the Web.Config file or in the Machine.config file. The default value for the maximum request length is 4096 KB (4MB). The maxRequestLength attribute indicates the maximum file upload size supported by ASP.NET.  More info: http://msdn.microsoft.com/en-us/library/e1f13641(vs.71).aspx

    HTH,
    Robert
    Robert Bruckner   http://blogs.msdn.com/robertbruckner

    This posting is provided "AS IS" with no warranties, and confers no rights.

    Wednesday, February 18, 2009 2:57 PM
    Owner