tailieunhanh - Lesson Crystal report

Lesson Crystal report presents about Advantages of Crystal Report; Features of Crystal Report; Crystal Report Creation Wizard; Step to create; Create Crystal Report using ; Binding Report – Passing Params; Sorting filed at runtime and something else. | CRYSTAL REPORT OBJECTIVES Crystal Report Advantages of Crystal Report Simplifies the process of analyzing data by generation of graphs. Accelerates the process of computing complex calculation. Displays data easily based on the search criteria. Displays data easily using various charts and graphs. Format Data easily. Features of Crystal Report Features of Crystal Report Crystal Report Creation Wizard Guide you to choose a data source and link to the tables It also guides you to sum up the totals, sort data, create charts and select records Standard Cross-Tab Mail Label - Mailing Labels Report Creation Wizard guides you to create a report that prints on a mailing label. Step to create Create Crystal Report using CrystalReportViewer cvrEmployee = new CrystalReportViewer(); SqlDataAdapter sqlda = new SqlDataAdapter(“Select * from Employees” , con); ReportDocument rdReport = new ReportDocument(); (“D:/”); DataSet ds = new DataSet(); (ds , “Employees”); (ds); = rdReport; Binding Report – Passing Params Binding report to the application by using CrystalReportViewer control. Passing a parameter on a database field allows the user to specify values for that field to filter the records. Sorting filed at runtime CrystalReportViewer cvrEmployee = new CrystalReportViewer(); SqlDataAdapter sqlda = new SqlDataAdapter(“Select * from Employees” , con); ReportDocument rdReport = new ReportDocument(); (“D:/”); DataSet ds = new DataSet(); (ds , “Employees”); (ds); = rdReport; FieldDefinition fdCountry = [0].Fields[“Country”]; [0].Field = fdCountry; [0].SortDirection = ; Report Viewer control Binding Report ReportDocument object model Is a powerfull and flexible model to handle the report at runtime. It provides many built-in class in different namespaces that are use to create , update and save report at runtime. One of the most important class in this model is the ReportDocument class. This class exits in the namespace Purpose and Format Exporting a Report Using the Export button on the toolbar of CrystalReportViewer Control Using the ExportReport() method of CrystalReportViewer class. This method invokes the Export Report DialogBox as bellow : Summary | CRYSTAL REPORT OBJECTIVES Crystal Report Advantages of Crystal Report Simplifies the process of analyzing data by generation of graphs. Accelerates the process of computing complex calculation. Displays data easily based on the search criteria. Displays data easily using various charts and graphs. Format Data easily. Features of Crystal Report Features of Crystal Report Crystal Report Creation Wizard Guide you to choose a data source and link to the tables It also guides you to sum up the totals, sort data, create charts and select records Standard Cross-Tab Mail Label - Mailing Labels Report Creation Wizard guides you to create a report that prints on a mailing label. Step to create Create Crystal Report using CrystalReportViewer cvrEmployee = new CrystalReportViewer(); SqlDataAdapter sqlda = new SqlDataAdapter(“Select * from Employees” , con); ReportDocument rdReport = new ReportDocument(); (“D:/”); DataSet ds = new DataSet(); (ds , .