SAP Reports 2011, WIN, INTL, NUL 7090310 用户手册
产品代码
7090310
Does the data exist or does it need to be calculated?
Some report information can be drawn directly from data fields (sales information, for example); other
information will have to be calculated based on data field values (for example, sales commission, based
on the relationship of sales to quota). In your planning, it can be helpful to segregate or flag data that
needs to be calculated from that which can be used directly. See
information will have to be calculated based on data field values (for example, sales commission, based
on the relationship of sales to quota). In your planning, it can be helpful to segregate or flag data that
needs to be calculated from that which can be used directly. See
What types of fields contain data?
You should take the time to get to know the data type for data fields that will be used in your calculations.
Since formula functions and operators work with specific kinds of data, it is important to recognize the
data type you are working with, before you start any calculations. For example, some functions require
numeric data, while others work with only string fields. For more information on specific functions and
operators, search for "Functions" and "Operators," or for the function or operator by name in the
Since formula functions and operators work with specific kinds of data, it is important to recognize the
data type you are working with, before you start any calculations. For example, some functions require
numeric data, while others work with only string fields. For more information on specific functions and
operators, search for "Functions" and "Operators," or for the function or operator by name in the
Crystal
Reports Online Help.
3.2.4 Manipulating the data
There are several ways to manipulate data when you design a report. The following sections list some
options you may want to consider.
options you may want to consider.
Do you want the data organized into groups?
How? By customer? By date? By hierarchy? Or by other criteria? Crystal Reports provides several
options for grouping data in a report. See
options for grouping data in a report. See
.
Do you want the data sorted based on record or group values?
Crystal Reports gives you both alternatives. See
Do you want the report to contain only specific records or groups?
Crystal Reports gives you the opportunity to 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. Take
a few minutes to determine the records needed for the report and list the criteria to be used for selecting
those records. See
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. Take
a few minutes to determine the records needed for the report and list the criteria to be used for selecting
those records. See
.
Do you want to summarize the data?
Do you want to total, average, count, or determine the maximum or minimum value included in all the
values in any column on the report?
values in any column on the report?
Crystal Reports allows you to do this, 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. See
grand total count, and so on) to be placed at the bottom of the selected column. See
.
What information should be flagged on the report?
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
inventory items are often flagged on inventory reports so they can be given special attention. You might
2011-05-16
54
Report Design Concepts