Description

Data processing allows to perform a processing of data from a document before they are placed into a report and becomes an additional data source for a reporting with its own attributes and relations. A data processing consists in computing of a data string or array of ones for a document. Depending on formula of computing a data string, by result of applying the data processing of documents can become either their detailing or integrating. The resulting array of data strings will contain only unique values and each such string will match to single document in database on which the string was computed. You can use document fields for computing the attributes and relations of data processing.

Documents Detailing

The detailing may be useful if a document of a database contains several data items and you want to use each of the items separately at a reporting. According to the data processing formula, each document at a reporting will be divided into several data strings, each of which contains the one data item of source document.

Documents Integrating

The integrating may be useful if documents contain the same data part and you want to use this part as data item at a reporting. A formula of data processing at reporting must compute the string whose equality in documents will mean their merging to the one data item for a report.

Adding

To create a documents data processing for a data source, do the next:

•	Open the view Data Sources;
•	Select the settings document of data source whose documents require the detailing;
•	Press Data Source \ Processing of Documents Data at the top.

The created settings documents are placed into the category with name of the data source and are displayed in the view as grey rows.

Settings

•	Field Name;
	Type a name for the documents data processing that is understandable for an user.
•	Section Computing of Processing;
	The setting defines how a data string for a document at reporting will be computed. The result of the computing ( a text ) will be written in the field KeyValue which you can link to when setting up attributes and relations for the data processing.
	•	Field @ Formula.
		Type an expression in Formula Language to compute a string or strings of data for a document in a database.
•	Section Selection Parameters;
	Create selection parameters if it's required. The selection parameters for documents data processing can only add the ones of parent data source, but not overwrite them. The parameters can be only of one type: Condition for Selected Documents. The condition must be typed in relation to the field KeyValue with value of computed data string. In the settings document of a selection parameter you should choose a data processing name just below the data source name.
•	List Available Attributes.
	Define the data source attributes which a user can choose as a column value when he had applied the documents data processing.

Besides the available data source attributes you can create own attributes for data processing. The values for such attributes will be computed from data strings for a document ( field KeyValue ). To create an attribute you should choose a data processing name just below the data source name in the attribute settings document. A user can choose the data processing attributes as well as available data source attributes at a report column setting.

If you want to relate documents of a data source and strings of a data processing ( or vice versa ) at a reporting, you should create the relation settings document. Choose there a data processing name just below name of first or second data source in the relation. If you want to create a relation of two data processings choose their names under the both data sources.

Topic links:

Selection parameters

Attributes

Relations

See also:

Data source ( Initial documents selection )