There are different Excel options to export the data of a Crystal Report. This format does export most of the formatting, however, it does not merge cells, and each element is added to only one cell. This format can also export certain summaries as Excel functions. This exporting format is an enhancement on the existing Microsoft Excel Workbook Data-Only exporting type.

Author:Kagarn Tojak
Language:English (Spanish)
Published (Last):16 April 2006
PDF File Size:20.74 Mb
ePub File Size:20.16 Mb
Price:Free* [*Free Regsitration Required]

Next Page Crystal Reports for enterprise provides an interface that enables you to quickly and easily create, format, and publish effective reports. The menu bar provides full range of features available in Crystal Reports for Enterprise as shown in the following image.

The standard toolbar as shown in the following image allows you to access common Report functions such as: Open an existing report, create a new report, save a report, print a report, cut, paste, export and undo. The Format tab as shown in the following image, allows you to use functions for formatting the selected field such as: changing the font size or font color, background color, alignment of text to center, left, right, etc.

It also allows you to apply conditional formatting, such as highlighting values above or below a specific threshold value in the report. When you click on conditional formatting option at top right corner, the formatting box open. In this box, you define the condition under which you want conditional formatting to appear. In setting area, specify the formatting to appear when condition is met, like changing font style or color of text. The Data tab as shown in the following figure, enables you to work with data-editing queries, creating groups and sorts, applying filters to limit data in the report and creating formulas to add custom calculations to reports.

When you click on Query filter option or on Edit data sources, as shown in the following image, a query panel opens. In the Query panel, you can select objects that you want to see in the report. In the filter option, you can apply filters to restrict the data returned by the report.

When you click on Formula button, as shown in the following image, the Formula workshop opens. This allow you to use custom calculations in the report. You can apply formulas by typing or by clicking on objects, functions and operators in the data explorer. The main working area in Crystal Reports is known as Report Design Canvas and is divided into structure tab and page tab.

Crystal Report is divided into five different parts by default and additional sections are added if you apply grouping to the report. Using the Structure tab, as shown in the above image, you can create the overall structure by placing items in various sections of the report. You can also apply any required sorting, grouping, etc. Here, you work with placeholders for data and not data itself. The Page tab, as shown in the following image, displays the report data on the basis of the structure you created in the structure tab.

Here, you can evaluate formatting and layout of the report design for distribution.


CrystalDecisions.Windows.Forms.CrystalReportViewer- Customizing the save dialog.



How to set default file name for export from CrystalReportViewer in ASP.Net


Related Articles