HelpConsole 2008 SP1 - ReportsDNA Manual HelpConsole 2008 SP1 - ReportsDNA Manual HelpConsole 2008 SP1 - ReportsDNA Manual HelpConsole 2008 SP1 - ReportsDNA Manual Home > Features > Templates > Template Settings

Template Settings


# Setting Description
1 File

Full path to file that contains the template
The template can be in a file that is external to the active workbook
Click the File button to open a File Browser dialog box to select a file.

2 Worksheet Specifies the worksheet that is will be used as the template.
3 Columns
 Specifies a range on the template that contains column names for the report.  These columns will then be available in the Column Selector for formatting the report.

For example, a data source contains a field named Date.  The template uses the Date field to derive a new field called Age.  The Columns range is used to make the Age field available so that the field can be formatted.

If the Columns range is NOT set, then the Age field will not be available since it is not returned by the data source (it is a derived field).

4 Detail A range of rows that indicate the template rows that should be used for
each record.

If set, the entire template will be copied for the first record, but
the application will only copy the detail range for subsequent records.

If not set, the entire template will be copied for each and every record.
5 View Opens the file that contains the template.
6 Edit Opens the file that contains the template and displays the template
field chooser dialog.
7 Multiple Records on Page Place multiple records on the same page until the record breaks
across a page boundary.
8 Table Style Use this feature when the template's layout is tabular. This enables
the report to use features (e.g. Group By) normally available only when
the report layout is a table.
9 Resize Row to Fit Text Resizes the row to fit the text each time a field is placed in a cell that has
Wrap Text enabled.
10 Record Spacing Number of blank rows used as a separator between records.

Allowable values: integer 0-10

Detail

EXAMPLE : Effect of specifying the Detail range setting.

Download example

BLANK RANGE SPECIFIED
The entire template is copied for each record.

Only the rows specified by the Detail setting are copied for
the second and subsequent rows.

Multiple Records Per Page

EXAMPLE : Effect of setting the Multiple Records Per Page setting.

Download example

UNCHECKED CHECKED
Each page contains one and only one record. Each page will contain as many records as possible. If a record
will not break across a page, it will instead force a page break.

Table Style

Download example

UNCHECKED CHECKED
Features that are normally restricted to reports in
Table layout are NOT applied (e.g., Group By) .		 Allows features normally restricted to reports in
Table layout (e.g., Group By)

Resize Row to Fit Text

Download example

UNCHECKED CHECKED
The row height of each row in the template is never altered
regardless of the size of the content.		 The row height for cells that contain Field placeholders
are resized (shortened) to fit the contents. This allows
for more records on a page.

Record Spacing

Download example

0 (no spacing between records) 3 (rows between each record)
Blank rows are NOT inserted between records Three (3) blank rows are used as a record spacer.





See also

Creating a Template