Customizing Reports

You can customize reports using the various options on the Layout tab and Field tab.

• Cell Padding. Opens the Cell Padding dialog box, where you can set specific values to control the amount of space inserted between rows and columns in a report. For more information, see How to Use Cell Padding in a Report.
• AutoFit. Limits the width of columns in a report to be no wider than the largest value in each column. When additional fields are added, the report automatically grows at design time. AutoFit Column is selected, by default.

• Page Break. Starts a new page when the primary sort field changes. Clicking the drop-down icon enables you to select Reset Page Numbers, which allows you to reset page numbers on a page break to start at 1.
• Line Break. Inserts a line in the report output when the primary sort field changes.
• Sub Header. Opens a dialog box where you can type text to add a subheading just below the column titles in the report output when the primary sort field changes.
• Sub Footer. Opens a dialog box where you can type text to add a subfooting at the end of the data on each page of the report output when the primary sort field changes.
• Subtotal. Inserts a line, total text (TOTAL FIELD Value), and subtotals for all numeric fields when the primary sort field changes.

The drop-down menu on the Field tab, in the Format group provides three field-type options for the selected column, which are Alphanumeric, Integer, and Decimal. Selecting the fourth option, More options, opens the Field Format Options dialog box, which provides further formatting options for the selected field. For more information, see Changing a Field Format.

Using the Currency Symbol drop-down list, you can apply options such as floating and non-floating currency. You also apply percent signs and commas using the check boxes on the Field Format Options dialog box.

To turn on the non-floating currency option, open the drop-down menu and select Non floating Currency. To turn off the non-floating currency option, click the Currency Symbol drop-down list again and make a different selection, or choose None.

The following options on the Field tab, in the Display group:

• Hide Field. Allows you to hide a selected field.
• Hide Missing. Allows you to hide fields that have no value.
• Aggregation. Opens a drop-down menu of the following options:
  • None (default)
  • Sum
  • Average
  • Count
  • Count Distinct
  • Percent of Count
  • Distinct Values
  • First Value
  • Last Value
  • Maximum
  • Minimum
  • Total
  • Percent
  • Row Percent
  • Median
  • Average Square

  Sum is the default aggregation type value for all numeric fields added to the Measure Query field container in the Query pane. Changing the Measure Query field container from Sum to Print, Count, or List overrides all assigned aggregation type values. For more information related to reports, see How to Display Numeric Measure Data Using Aggregation Options in a Report. For more information related to charts, see How to Display Aggregations on Measures.

• Traffic Lights. Opens the Traffic Light Condition dialog box. From this dialog box, you can do the following:
  • add new conditional styling by applying traffic light (and other) colors to a selected field in the output when the field meets specified criteria
  • modify existing conditional styling
  • enable conditional drill-down

  For more information related to reports, see Styling Reports. For more information related to charts, see Traffic Light Condition Dialog Box.

• Data Bars. (Reports only.) Adds a data visualization column to the right of a selected numeric field. The column displays values in each row using horizontal bars that extend from left to right in varying lengths, depending on the corresponding data values. For more information, see How to Add Data Visualization Bars to a Report.
• Within. Allows you to use specific aggregation tasks at different report levels. You can use the Within phrase to manipulate display field values as they are aggregated within a sort group rather than a report column. For more information, see How to Access the Within Functionality.
• Column(s). Allows you to indicate the number of columns in which you wish to display multiple graphs. The value can be between 1 and 512. The default is 1. This option is also available from the Query pane shortcut menu for a Multi-graph component.