.NET crystal reports

When crystal reports are integrated with .NET, data can be accessed using ODBC drivers, ADO drivers, database files like excel, xml etc. Accessing data from data sources like ODBC drivers is called as the pull technology. In pull method, a built in wizard is used to select source to pull data from and the tables and fields are then selected to use in the report. In push method data set is created at run time and passed to the report.

When .NET application uses crystal reports, the following components are required:

Report files: .rpt or report files needs to be distributed which can either be compiled into the application (Embedded) or independently (non embedded) from the application.

Crystal reports merge module: The merge module ensures that the correct report components and component versions are installed with the application.

.Net Framework: - .Net framework must be available on the client machine.

Crystal reports offer a report designer. First, select specific rows and columns from a table. Using the designer, the data on the report can be rearranged and formatted. Once the layout is complete, the report needs to be saved as .RPT.

Crystal Reports requires a technical hand to put together a report, whereas in BO, the end users can drag and drop fields to create the report on the fly

Select the field

Click FORMAT

Click FORMAT FIELD

Select the FONT tab

Click the FORMULA BUTTON to the right of FONT

if ({YourField} = Value) then

"Arial"

else

"Times New Roman"

Click SAVE Icon

Close the formula editor

Click OK on the FORMAT screen

Calling crystalreportcontrolname.reset (by selecting Report menu under Refresh the report menuitem at design time) will refresh the report.

You can create 256 subreport in a main report . But you can't create a subreport within a subreport.