Standard Reports

 

The Standard Reports document contains the following components:

 

Types of Reports

There are three types of reports: Pivot, Vertical & Tabular.

Pivot

Vertical

Tabular

Report Builder Section

The Report Builder section is where the report is created (Output).

 

How to use Standards

Importing the Standard (style sheet)

Report Style: Pivot, Vertical & Tabular

\\SVR-FS3\TechStaff\V7_System Reports\Styles\v720 Style.repss

 

Only Pivot

 

 

 

 

Using the Wizard

  1. Go to the report and then run the report wizard.

 

  1. Select the file from \\SVR-FS3\TechStaff\V7_System Reports\Styles\v720 Style.repss

 

 

  1. Click the Next button.

 

 

  1. Click the Next button again.

 

 

  1. Make sure to select each corresponded style to each band.

 

Standards to Use

This section contains the following components:

 

Report Header

  1. Similar to Pivot, Vertical and Tabular, the report header has a filter, title and logo.

  2. The style for the Report Header is: ReportHeader1.

  3. The logo is in: \\SVR-FS3\TechStaff\V7_System Reports\Styles.

  4. The style for the filter is: Verdana 6 and size height 12.

 

 

  1. The Main Title uses words like “By”, split in two lines. When it needs more than one line it has to use these fonts:

 

 

  1. The filter must use the Imported Controls/Filter and set the following properties:

 

 

 

  1. Second Control shows the Value from the series parameters.

 

 

  1. Logo: Set the color logo of Mtech useing the following Image option:

 

 

Page Header

As in Pivot, Vertical & Tabular, it is necessary to maintain the consistency of the title in the header. If the title has two words, split it in two lines. If the report is grouped, it will go to the Group Header. If not, it will go to Page Header. The style of the page header is: PageHeader7pt.

 

 

 

Group Header

Group Head is the same as Pivot, Vertical & Tabular. The Group Header was updated with font Verdana-7. The style of the group header is: GroupHeader7pt.

 

 

 

Group Footer

Group Footer is the same as Pivot, Vertical & Tabular. The style of the group footer is: GroupFooter7pt.

 

 

  1.   Type the word `Subtotal` followed with bind field in the group footer.

 

  1. Bind the Label with the Group Field.

  2. Add the Word “Total” as part of the Label Format String. See the image below:

 

 

Report Footer

Group Footer is the same as Pivot, Vertical & Tabular. The style of the report footer is: ReportFooter7pt.

 

  1. Report footer is almost the same as the group footer but with the Word “Grand Total” and there is no need to bind the field.

 

 

Page Footer

The Page Footer is the same as Pivot, Vertical & Tabular. The style of page footer is: PageFooter7pt.

 

  1. Remember to use Layout ID. Layout ID is the combination of the Report ID +_+Correlative.

  2. The following is 1 layout of 4.

 

 

  1. Use Font Verdana 7pt. The Foreground color must be Gray.

 

Detail

 

Reports

The Reports section contains the following items:

 

 

Pivot Example

 

 

 

Vertical

 

 

How to Attach a Sample Image of the Output

  1. In the output, select the Preview tab.
  2. In the menu, select The Images option.

  3. Click the option `Attach Sample Image` and save the output.

 

 

How to Export the Output like PDF

  1. In the output, select the Preview tab and in the Toolbar, select the `Export Document` option (Diskette Icon).
  2. Ensure the Option PDF File has been selected.
  3. Click the Diskette bottom and enter `1` in the page range to export only the first page of the output.
  4. This file must be copied in the following Path: \\SVR-FS3\TechStaff\V7_System Reports\PDF.
  5. This PDF has to follow this nomenclature name: Report ID + Report Layout Name.

 

 

 

 

 

 

How to Export the XML to the System Folder

  1. In the Report Definitions, select the Options icon.
  2. Click the `Export to File` option.
  3. In the Report Export Selection, select the reports to export.
  4. Select the Path where you will export the Report XML (Ex: 7.25 XML if you are developed the report in this protein version).
  5. Click the OK button and it will show an Export Result Message.

 

 

 

 

Graphics

 

Axes Title

 

Grid Lines

 

Point Labels

 

Chart Title

 

Legend

 

Useful Report Tips

This section contains the following components:

Process Duplicates

Process Duplicates is used if we don’t want to display a duplicate value (based on a TAG).

  1. Select the field that you don’t want displayed.

  2. Properties> Behavior>

 

  1. In Data Binding, select the Tag Field. My example: TrackingNo

 

Using a Pivot in a Tabular Report

This is used when it is necessary to refresh the data based on the Group:

 

  1. Select the Pivot> Event> Before Print.

 

Finding the IRN Values of a Field

  1. Select the Field from the Field List.

 

  1.  A pop-up message will show the IRN.