Introduction of Crystal Report in C#.Net
Crystal report is a report designer tool to design and generate report from wide range of data source such as database, xml file etc. Crystal Reports allows users to graphically design data connection’s and report layout. Users can select and link tables from a wide range of data sources such as MS-Excel spreadsheets, SQL database, Oracle database, and any file system information. Fields from these tables can be placed on the report design surface, and can also be used in custom formulas. Formulas can be evaluated at several phases during report generation as specified by the developer.
There are lots of feature in Crystal Report, from which some are given as follows:
1. Common Standard File Format
2. Embedded Crystal Report Designer
3. Data and .Net Data set Connection
4. Report Viewer
5. Export and Print
6. Report Web Service
7. Crystal Web Service
8. Merge Module Deployment
9. Runtime Support for previous version
Common Standard File Format:
A common standard file format allows for feature-rich reports that contain data retrieval criteria, grouping, summary and parameter linking information. According to this feature Crystal Report generates report in .rpt extension file, which is common standard. The .rpt file consists of a report definition format that contains not only data retrieval criteria, but also grouping, summary, parameter.
Embedded Crystal Report Designer:
Visual studio comes with embedded crystal report designer, basically embedded crystal report designer is GUI application, using collection of wizards and experts, and through which complex report file can be generated quickly and easily.
Data and .Net Data Set Connection:
Data and .Net Data set connection are widely used to connect different types of data source with Crystal Report Designer, i.e. Crystal Report designer can easily interact with any type of data source with available connection.
Report Viewer is a control which is widely used to display crystal reports on window form, i.e. we can easily display crystal report on any window form.
Export and Print:
Through the Export wizards we can easily exports or save crystal reports in many extensions such as .pdf, .rpt, .xls, .xlsx, . doc, .docx, .rtf, .csv, .xml and much more. Whereas Print provides an efficient way through which we can print crystal reports.
Report Web Service:
Report Web Services enable any application that can read XML to access and use reports. With the help of report web service we can publish Crystal Reports as web services, i.e. report’s interfaces are available in XML and can be transmitted across the internet.
Crystal Services allows programmatic access to your reports through a web service. Crystal Service allows user to access a crystal reports as server file through web service.
Merge Module Deployment:
Merge Module deployment ensures that crystal reports component and assemblies are added with deployment project correctly or not.
A merge module is a set of components that are merged with a Windows installer for applications that need them. The components may include a .dll file, resources, registry entries, setup logic, and related files. With all related components stored in a single container, the installer eliminates version conflicts and other common installation problems.
Runtime Support for Previous Version:
Runtime Support for Previous Version provides the feature through which, crystal report project which is created on previous version supported at runtime and no modification require at designing time.