Crystal Reports  

Manipulating Data

Organize Data into Groups

Crystal Reports provides several options for Selecting Records and Grouping Data in a report.

You can base a report on all records in a given database, or on a limited set of records from the database. Crystal Reports can be used to select records based on simple date ranges or comparisons, or to create complex formulas to identify the records to be included.

Summarize Data

Do you want to subtotal, average, count, add percentages, or determine the maximum or minimum value included in all the values in any column on the report?

Crystal Reports allows you to accomplish all of these calculations, and it also allows the grand total (or the grand total average, grand total count, and so on) to be placed at the bottom of the selected column.

Flag Data

You may want to call attention to some data by flagging it on the report. For example, non-moving inventory items are often flagged on inventory reports so they can be given special attention. You might want to flag each item that has shown no activity during the last month, during the last three months, or during some other defined period. To flag information, identify it and any conditions that will trigger the flagging.

Format Flagged Data

Crystal Reports gives you the opportunity to underline report elements, and to change the font type, size, or color used for specific report items. It allows you to put borders around items, to draw lines and boxes (to break the report into sections), to set off headings, and so on. All of these formatting tools can be used to highlight key data on a report.

See Also

Inserting Formulas | Formatting Data