As you decide how to display report data, you may wish to create charts to highlight key information. When you create a chart, you can place it in the Group Summary, Query Summary, or Report Footer section of a Tabular report, or you can create the chart as a separate report. Charts require numeric columns. As a result, you cannot create a chart if your query does not contain numeric columns.
The following sections discuss:
Production Reporting reads a null numeric column field as a zero. This affects numeric columns containing null values and used as groups in a chart. Consequently, if you group values in a chart, code your query to exclude null fields used as grouped values. For example, if you create a chart to show employee salary by region number, Production Reporting does not distinguish REG_NUM=NULL (employees with no region assigned) from REG_NUM=0. If you group a chart by a non-numeric value (region name, for example), the chart will display correctly.