Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-Server C#4.0 SSRS
Hi,
 
Can one please tell me what's the difference between an .rdl and an .rdlc in Reporting.Also,I have a scenario,the scenario is like this:
 
I am doing School management application,which is a windows application purely.In this app i have a button in form ,on click of this i should generate a report dynamically ,connect to dataset and pick the data and finally i should be able to render report .How to do this,
 
Please help me.
 
Thanks in Advance.
 

Regards
Chaithanya M
Posted 23-May-11 0:51am
Edited 23-May-11 1:08am
v2
Comments
SAKryukov at 23-May-11 10:25am
   
I would advise you to stop using the format "What is the difference between {0} and {1}?". What's the difference between apple and Apple. Any possible answer could be considered incorrect. Ask what do you know to learn about two or more items, exactly.
--SA
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

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.
 
Ref:http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/a5f67556-7223-492f-b8d8-77b118b2cb2c/[^]
 
How to do that?
http://msdn.microsoft.com/en-us/library/ms170246(v=sql.90).aspx[^]
 
You can google[^] for more information.
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

Hope this[^] might help you.
  Permalink  
Comments
M.CHAITHANYA at 23-May-11 6:19am
   
Hi Ramalinga Koushik,
 
Can you please tell me how to create a report dynamically and show it through Report Viewer to the end user.
 
Regards
Chaithanya M

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



Advertise | Privacy | Mobile
Web03 | 2.8.1411022.1 | Last Updated 23 May 2011
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100