Report Data View properties

The following properties are common to both types of Report Content:

Report Matrix and Table Views show the same Characteristics page, including:

• "Public" (default): the Report Data View can be reused in several reports. The Report Data view is available at Report Template or Report Chapter creation.

• "Private" : the Report Data View cannot be reused.

• Display, which defines the display associated with the Report Data View:

• "Graphic and table"

Report Matrix and Table Views include the same Filters page, which enables to define which filters can be displayed in a report for this Report Data View.

A filter enables to restrict a Report DataSet column values, which are considered in the report. This Report DataSet column is not necessarily part of the report.

Each filter is defined by the following Characteristics:

• Visibility enables to hide the filter when it is fed by another filter or to display its value only.

• Object Edition Mode defines how objects are displayed and whether they are editable or not.

• Behavior defines the filter action on the report:

• "Immediate Refresh" (for a report easily calculated): as soon as the user modifies the filter the report is updated.

• "No Refresh": the user needs to click the Refresh button to update the report.

• Input type defines how the report user can define its condition:

• "Multiple values" when the column includes a restricted number of values.

• "Continuous" to define a range of values.

The condition is also column data type dependent.

An initial value is the default value on report opening.

Candidate values are the values the user can use for a specific filter.

The paragraph content depends on the filtered data type.

• Occurrence, the values are defined either by:

• an object defined a conventional variable:

• an object list explicitly defined in field form:

• a set of occurrences obtained by applying a condition on the DataSource item occurrences

All of the occurrences, whose short name includes "character string".

• a set of occurrences retrieved by a query execution

Query = ~Query quoted : the values retrieved by the quoted query.

If the query does not include a parameter it is executed straight away, else the included parameter is valued by the report parameter quoted in the Parameter variable.

Queries including more than one parameter are not exploitable.

Defines the report parameter which enables to value the query parameter.

• Tabulated value attribute, the values are defined either by:

• a list of internal values explicitly quoted

Example: certain values of a multivalued attribute.

• a set of values obtained by applying a condition on the attribute internal values (numerical values)

• an object defined by a conventional variable

• a list of dates explicitly quoted (Mega internal format for dates)

• a set of dates obtained by applying a condition on the DataSource item occurrences

ValueInferiorTo="date" : all the dates < to the date.

ValueSuperiorTo="date" : all the dates > to the date.

• a list of explicit values

• a set of values obtained by applying a condition on the DataSource item occurrences

All the Report Data View types include the same Style page, which enables to:

• define the style to apply to the Report Data View

• have a picture of the Report Data View items on which a conditional style is applied.

The Matrix page is specific to Report Matrix views. This page defines the matrix content, i.e. the data source columns on which is based the matrix:

• In Rows Definition and Column Definition sections:

• Rows and Columns attributes define the content of all the rows and columns displayed in the matrix. The displayed data is provided by a Report data Source Element.

• Data Source item attribute defines the Report Data Source Element, which provides the data.

• Sort attribute defines which sorting is applied to the row/column.

• Show all values attribute defines if all the column possible values are displayed in the report. It is used only when rows or columns match a set a known values.

• Cells attribute defines the content of all the cells displayed in the matrix. The displayed data is provided by a Report Data Source Element.

• Data Source item attribute defines the Report Data Source Element, which provides the data.

• Report Cell Content attribute defines what is displayed in the cell.

• Value computation attribute defines which computation is applied to the set of values grouped in the cell. It operates only for cells with numerical values.

• Object Edition Mode attribute defines how objects are displayed and whether they are editable or not.

The Bar Chart page is specific to Report Matrix views for which the Chart type is "Bar chart". This page defines which matrix element defines:

The Table page is specific to Report Table views. This page defines the table content through the following parameters:

• Data Source Item: to define the data source columns on which is based the table.

• Display order: to define the column appearance order (if not specified, the row order is considered).

• Sort and Sort priority: to define the sorting direction and in which order it is applied.

• Group: to merge the pre-sorted set of cells showing the same value.

• Value Computation: to define a computation when the tab includes a grouping.

the Sub-total section defines the sub-total or total rows that have to be added to the table:

Each sub-total row includes the following attributes:

• Subtitle: to add a subtitle, regarding the column, in the break. You can define the title ("Given subtitle") or keep the automatic title ("Automatic subtitle" which is defined from the computation function name). Default value is "No subtitle".

• On column value change: defines on which value break the row appears

• Break type: defines where the row appears ("Subtotal" or "Subtotal and grand total")

On the row you can display several computation results performed on each column including numerical values.