Page History

...

The Section format tab contains a number of menus that you can use to format the report sections.

Image Added

Each of these menus sections is described below.

Image RemovedImage Added

Section Selection

Using the Report format menu and selecting the 'Section' tab you will be able to apply formatting and summaries for each section that you have in your report.
Navigate to the Section tab and if you have multiple sections in your report select the section you wish to format from the field drop down list.

Image Removed

Display

The display drop down option allows you to manage the options associated with how the section will be displayed on the report such as format.

Expand
title Display
Option Description Display

...

...

Define the

...

title of the section

...

field. Format Each data type will have a unique set of format options -

...

eg Text, Date or Numeric. See

...

Chart Title

...

If you have charts on your section report there will be a separate chart for each section. To use the section name as the chart title check this item.

...

Show Labels

...

If you wish to suppress the labels of the section uncheck this option and the column name will be removed but the section value will continue to be displayed. Note: this option is not available if the Section Style is set to Tabbed.

...

Section Style

...

• Single Page - View the report, and its sections, on a single page.
• Section Per Page - Yellowfin allows you to break your report into multiple pages. This is particularly useful if you have a lot of data to display on a single report.
  Image Removed
  If you wish to have a page break per section select 'Multiple Page' as the Section Style and the report will have multiple pages - one for each distinct section value.
  Section breaks are not only used for web display but are also used when exporting for example to a PDF file.
• Tabbed - You can also choose to break your report into tabs. This is a visually clear and easy to navigate way of splitting your report.
  Image Removed
  To set up tabs on your report select 'Tabbed' as the Section Style.

Display Formats for details on each type. Sub Format Depending on the format option you have chosen for the column above you will have a separate set of sub format options. Select the appropriate sub format option. Section Style Select from three available section display styles: Single Page: displays all sections on one page. Multiple Page: displays each section on a separate page. Tabbed: displays each section on a separate tab. Note: only the top section field has the Tabbed option available. Show Labels Display or hide the field name label for each section, before the section value.

Expand
title Style

Style

...

Option Description Display Style

...

Define the

...

formatting style for each section heading.

...

Font Style When the Custom display style is selected, define the formatting to be applied. This covers the font face, font size, font colour, and font style. Background Colour When the Custom display style is selected, define the background colour for the section heading. Alignment Define the alignment for the section heading.

Expand
title Summary

...

Alignment

...

Select from Left, Centre, or Right.

Summary

...

Option Description Section Summary

...

Define the field to be used as a section summary table at the top of

...

the

...

report.

...

Section Total

...

Display totals for each section. Show Labels Display

...

a field name label for the sections, before the section value. Grand Totals

...

A grand total can also be displayed at the end of the report. This will sum all the sections into one total. To active this function you need to select the Grand total option in the summary drop down.

Display grand totals for this section.

Expand
title Sort

See Summaries for more information.

Sort

...

...

Option Description Sort Direction

...

Define the sort direction, ascending or descending, for the section values.

See Sections for more information.