Embedded Reports

Movicon offers an "Embedded Report" resource that can be used to create reports to display historical data or project variables.  A Movicon Embedded report object is represented as a Screen object divided into five predefined sections called bands.   Different objects and symbols, such as displays and charts, can also be added and become part of the Report's features.

Embedded Report Resource

New "Textual Reports" or "Embedded Reports" can be added by using the following commands:

• The "Add a new Report" command from contextual menu which appears when right-clicking on the "Embedded Report" group from the Project Explorer window.

• The "New Report" command available from the "Commands" section located at the  bottom left of Project Explorer Window.

• The "Add a new Report layout in the project" available as an icon form the Movicon Toolbar.

When you add a new Report object, it will open in the Movicon workspace as a screen. The Report will be created with A4 paper sizes, which will be expressed in pixels and calculated by Movicon based on the screen resolution, with a white background whose color can be changed afterwards, and divided into seven Bands.  These bands also have their own default sizes which can be changed appropriately as needed. Each Band has a different role to play within the Report layout and will only be accepted for printing if it includeds objects in the final report.  The Bands are separated by a line only in design mode to determine how much space can be used to add objects.  They will not be shown in the final report. The seven Bands in question are:

• Page Header (one per page): represents the area for the page header. This band will be repeated on all pages.

• Report Title (one per report): represents the area for inserting the report title. This band will be printed once only on the first report page.  When this band is printed as a single page  (enabled  "Keep in Separate Page" option),  the "Page Header" will not be printed on the page dedicated to the report's title. The use of the Report Title band may result useful when needing to generate a multiple report containing several reports that are all printed one after the other at the same time when using the print command (see section on  "Report-Recipes Commands"). In this case, the "Report Title" will be repeated once on the first page of the first report listed, while the "Report Header" band will be printed for each of the reports listed.

• Report Header (one per report): represents the area for the Report Header.  This is also a container of any graphs that may need to be placed at the beginning of the Report. This band will be displayed on the first Report page only, after the "Report Title" band.

• Details Header: represents the area for the "Details" band. If data in the Details area occupies more than one page, the "Details Header" band will be repeated and displayed on all the pages containing "Details" before the "Details".

• Details: represents the area where objects are inserted (i.e. displays) to display variable values and historical log values extracted from the database by using queries. This band, and the objects it contains, can be duplicated on the page and distributed to other pages when needed so that information from all the recordsets obtained from the database when queried can be displayed. If the Report has not been associated with a Database because if is being used to display RealTimeDB variable values, the Details band will not show while the report is being created.  As a result, any objects inserted in this band will not be shown either.

• Report Footer  (one per report): represents the area in which Graph type objects (i.e. Trends) are arranged and shown on the last report page.  This band will only show on the last Report page.

• Page Footer (one per page): represents the area of the Page Footer.  This band displays on all the Report's pages.

Each Band can be configured through their  "Height" and "Keep in Separate Page" properties, as described in the respective paragraphs.

Report Objects and Displayed Data

Different types of objects can be added to the Reports to display specific data.  These objects are those found in the "Object Toolbox" for Reports.  This toolbox is available when the Movicon Embedded report is opened in edit mode within the project's workspace.  These objects come with a set of properties and belong to a subset of objects that can be inserted on Screen.  

In addition, objects that can be inserted in reports, such as Screens for instance, can be grouped together as composed Symbols and then inserted into the "Symbol Library" for later use.

The following types of data can be associated and displayed in Report objects:

• Project or Child project RealTimeDB variables.

• Fields containing data extracted by queries from tables associated to the Report

• Alarm statistical values  (only when  "Alarm Statistics" has been enabled)

• Report or system information, displayable exclusively through designated objects such as the "Date Time", "User", "Query", etc.

Values to be displayed in the Report objects can be inserted by editing the data entry fields manually or by simply selecting them from the  "Tag Browser Window" window.  In addition to the tab used to select variables, there is also a  "DB Field"  tab which you can use to select the database fields.

You can also use different types of animation for those objects that can be inserted in the reports. These types of animation include Visibility, Transparency, background color, and others. This will allow you to animate specific objects differently according to which of the project's variable values has been acquired.  Object animations can only be edited while the report is being created.  They cannot be edited when the report is displayed or printed.  The following animations can be used:

• Visibility (object may be made visible or invisible but it cannot blink)

• Transparency (this functionality is not supported in Windows CE)

• Scale

• Rotation (this functionality is not supported in Windows CE)

• Text - Display Value

• Background Color

• Dynamic Text and Text and Edge Color

• Gradual Filling (available only for objects from the "Basic Shapes" category)

• Dynamic Images (objects can display images but the automatic scroll cannot be used if they have muliple images)

The animations listed above can also be used for objects in the "Details" section. When doing this, you can use the DataBase field instead of an animation variable so that the object will animate with the value of the current record for each line displayed in the report For example, let's suppose a display object has been inserted in the "Details" band to display a DataLogger field associated with the same Background Color animation as the one used for the DataLogger field. At this point, when the Report is generated, for example by extracting the last 10 records from the datalogger table, the ten display objects displayed in the Report will obtain a different set background colour based on the value shown.

Basic Expressions in objects

Basic expressions can also be inserted in object fields where the variables are inserted.  In this case, however, it is not possible to use expressions in database fields (DB fields, i.e. DF:VAR00001]) or special fields (SP fields, i.e. [SP:time]), where only variables from the RealTimeDB can be used.

Report and Alarm Statistics

The Movicon "Embedded Reports", can be used to create reports on data recorded by the project's DataLoggers and Historical Log.  Reports that are created for project "Alarms" can also be created for alarm statistics, as described in the paragraph on "Alarm Statistic".  Predefined reports on alarm statistics are provided in the Movicon installation folder and they can be customized or news ones can be created.

Reports on variable trace tables can also be created.  In this case, the variable Trace must be set with the same DSN used by the DataLogger (or Historical Log).  By doing this, the variable table will be created within the same DataLogger database (or Historical Log).  When using Embedded Reports, the "DataLogger/Recipe" ( or Historical Log) item must be set as "Data Source Type", and the name of the DataLogger must be selected in the "Data Logger/Recipe" field (or a table in the "Event Log Type" field).  At this point, it will be necessary to insert a customized "Query Report" to extract data from the variable trace table and not from the DataLogger table (or Historical Log).  For example, if the variable being traced is called  "VAR00001", and the table has the same name as the variable, the query should then be:

Select * From VAR00001 Order By LocalCol DESC

Operations for editing Reports and multi-object selections

When editing Reports, you can execute specific operations by using the SHIFT key:

Selecting Report Properties: to display properties belonging to the Embedded Report resource in the Properties Window, simply click on the Embedded Report's name in the Project Explorer window or click on any Report band, in an area not containing objects, while keeping the SHIFT key pressed down.

Selecting Report Band Properties: to display properties belonging to the Embedded Report's Band, simply click on the band in an area not containing objects.

Multi-object Selecting: to select a number of objects contained in an Embedded report, as well as those belonging to different bands, simiply click on each object while keeping the CTRL key pressed down or by dragging them with the mouse while keeping the SHIFT key pressed down.

Modifying Band sizes: to change the band's height size:

• Change its "Height" property located in the Properties Window.

• Select the interested band with the mouse, then click on the small square located in the center of the band's bottom separation line and drag it further down to enlarge it or drag it up to reduce it.

• Select the next band to the one you wish to change, click on it with the mouse and drag it down to enlarge the one above.  This operation method cannot be used to enlarge the "Page Footer" band which is the last one on the Report.

Functionalities which are not available in Reports

The Reports are used to display values of historically logged data for specific time ranges which can then be printed or saved as documents. However, once the Report has been created, it can no longer be edited. It is for this reason that functions and properties which are made available when editing the Screen resource are not available when editing the Embedded report resource along with the objects which have also been added.

The procedures that cannot be performed and the functions that cannot be used in the Embedded Report resource are:

• It is not possible to edit Basic Script code within the Report resource or its object content.

• It is not possbile to edit IL Logic within the Report resource or its object content.

• It is not possible to use the Report resourse's local variables.

• Objects inserted in Reports cannot be edited, therefore all the properties used for inserting data or for executing commands are not available for use.

Advantages and Disadvantages of using Movicon Embedded Reports

When reports have to be created within the project, it will be necessary to evaluate which of the report type to use between the Movicon Embedded Reports, the "Report Designer", or the "Crystal Report" external libraries based on specific needs. Below listed are the advantages and disadvantages of using the "Embedded Reports" compared to the  "Report Designer" or "Crystal Reports":

Advantages:

• The Movicon Embedded Reports are compatible with Windows CE.

• The Movicon Embedded Reports also support the "InMemoryDB" database format (along with any database limits).

• Multilanguage reports can be created with the Movicon Embedded Reports by using the read-to-use integrated change language management.

• Vectorial graphics from the Movicon Symbol Libraries can be used in the Movicon Embedded Reports.

• Variable values within the project can be displayed in the Movicon Embedded Reports without having to write script code.

• Certain types of graphical animations, such as Visibility, Transparency, Background Color, etc., can be used within Embedded Reports which are evaluated during the Report generation phase.

• The Movicon Embedded Reports integrate the advantages of using the Movicon editor while creating reports: Cross Reference, Refactoring, Renaming Management, Check for Missing Strings, XML Structure, etc.

• The Movicon Embedded Reports for alarm statistics must not be modified when customizing the names of the Historical Data Log columns (Movicon will take this into account during the report generation phase).

• The Movicon Embedded Reports show statistical information for each individual alarm for alarm statistics (Total Time ON, number of ON/ACK/RESET events).

Disadvantages:

• The ToolBox used in the Movicon Embedded Reports contains a limited number of objects.

• Sub-reports and automatic data groupings cannot be managed in the Movicon Embedded Reports.

• Simple data calculations to be printed cannot be performed in the Movicon Embedded Reports (calculations must be first done using the Movicon logic whose results are then applied to the variable before generating the report).

• Reports can only be saved or exported in  "PDF" format when using the Movicon Embedded Reports.

• Basic Script code  ("wwb.com" or "wwb.net") cannot be used in the Movicon Embedded Reports to manage advanced reports.

• Reports cannot be displayed on Web pages using the Movicon Embedded Reports.

• Sub-reports cannot be used for alarm statistics with the Movicon Embedded Reports and, as a result, detailed alarm information cannot be accessed through report display windows.