programming we consider all important topic for knowledge about controls,web Services, JSON, Ajax, database, and interview related Question. In this and sql server tutorial blog we give many examples of jquery as like How Play YouTube Video in Your Website by URL, How to Play YouTube Videos in by using Jquery , Jquery Change div background on mouseover in , JQuery UI Datepicker (Calendar) etc.

Friday, September 19, 2014

Advantage of using Crystal report in C#

Advantages of Crystal Reports:

As we know that Crystal Report is use for reporting. Means when we want to print some things by website or application then we can use CrystalReport. When we make my own project then we need print many forms as like registration form printout user password and username printout and other then we use crystal report. And the Next time when we work on online Fee management web application then again use this.

Major advantages of using Crystal Reports in

  • Rapid report development since the designer interface would ease the coding work for the programmer.
  • Can extend it to complicated reports with interactive charts and enhance the understanding of the business model
  • Exposes a report object model, can interact with other controls on the ASP.NET Web form
  • Can programmatically export the reports into widely used formats like .pdf, .doc, .xls, .html and .rtf
  • Secure as End user cannot modify the data which is appear in the report if we use crystal report to show the report but in HTML, user can modify the report data.
  • Report layout is not transparent, so that end user will not know about how we design the report. But in HTML, anybody can study the report layout and can copy the technology.
  • Can export into different format like PDF, HTML, XML, etc.

Crystal Reports  Implementation in Models:

Crystal Reports need only database drivers to connect to the data source for accessing data. Crystal Reports in .net support two methods to access data from a data base.
There are 2 methods for using crystal report in
  1. Pull Method.
  2. Push Method.

The Pull Method of crystal report:

This type of model crystal report is used to access data from the data base, the database driver directly access the data from the database. This model does not need to developer to write code for creating a connection to database and retrieving data from the data source. This type of Crystal report managed by the SQL commands for connecting by using the specified driver.

The Pull Method of crystal report
Pull Method of CR

The Push Method of crystal report:

This type of model is used to access data from data base, and then the developer writes the code to connect to the data base and retrieve data. The data from the data base is cached in dataset and multiple crystal reports accesses data from the dataset. 

Other Crystal Report Related Post: Related Other Post:

No comments:

Post a Comment