Reports Wizard: application for the reporting in IBM Lotus Notes. Help: Relation.

Description

A relation settings document defines a relation between the data elements ( documents or strings ) matched to two data sources. Report structures which could be created by a user depend on the settings documents.

Adding

To create a relation of two data sources, do the next:

• Open the view Data Sources;

• Press Relation at the top.

The created relations are displayed in the view Data Sources inside of categories with names of first and second data sources and marked by green color.

Settings

• Section First Data Source;

Sets the parameters for the first data source in the relation.

• Field Data Source;

Choose name of a data source from which the relation with second data source is being set.

• Field Data Processing;

Choose name of a documents data processing in order to set the relation from its data strings instead of the documents of the data source.

• Field @ Main Expression;

The expression computes values for the right part of selection formula of the method NotesDatabase.Search after the equal sign "=" which will be called at reporting to select the documents to second data source of the relation for the purpose of their subsequent comparing with the values of the first data source in the relation. The equality between the computed values of the first and second data source means a relation of the data elements of the sources. If a data processing was chosen you can mark Compute with KeyValue in order to compute the values for data strings of the source ( field KeyValue ) instead of documents.

• Fields @ Add. Expression ( 1 - 3 ) ( optional ).

Type an expression to compute the result which will be compared to the result of the expression typed in the similar field of second data source at reporting. The comparing will be applied after setting a relation by Main Expression. The equality of the expressions results will mean the relation of data elements of the first and the second source. If a data processing was chosen you can mark Compute with KeyValue in order to compute the values for data strings of the source ( field KeyValue ) instead of its documents.

• Section Second Data Source;

Sets the parameters for the second data source in the relation.

• Field Data Source;

Choose name of a data source with which the relation from the first data source is being set.

• Field Data Processing;

Choose name of a documents data processing in order to set the relation from its data strings instead of the documents of the data source.

• Field @ Main Expression;

The expression is pasted into the left part of selection formula of the method NotesDatabase.Search before the equal sign "=" which will be called at reporting to select the documents for the second data source in the relation. For details see the description of the field in the section First Data Source above.

• Fields @ Add. Expressions ( 1 - 3 ) ( optional ).

See description in the section First Data Source above.

• Field Relation Name ( optional ).

Type a name for the relation, if you plan to create more than one relation for the two data sources. A user can choose what relation he wants to apply in a report.

The relation described in the settings document is oneway only: from first data source to second.

Topic links:

Data source ( Initial documents selection )

Processing documents data

•	Open the view Data Sources;
•	Press Relation at the top.

•	Section First Data Source;
	Sets the parameters for the first data source in the relation.
	•	Field Data Source;
		Choose name of a data source from which the relation with second data source is being set.
	•	Field Data Processing;
		Choose name of a documents data processing in order to set the relation from its data strings instead of the documents of the data source.
	•	Field @ Main Expression;
		The expression computes values for the right part of selection formula of the method NotesDatabase.Search after the equal sign "=" which will be called at reporting to select the documents to second data source of the relation for the purpose of their subsequent comparing with the values of the first data source in the relation. The equality between the computed values of the first and second data source means a relation of the data elements of the sources. If a data processing was chosen you can mark Compute with KeyValue in order to compute the values for data strings of the source ( field KeyValue ) instead of documents.
	•	Fields @ Add. Expression ( 1 - 3 ) ( optional ).
		Type an expression to compute the result which will be compared to the result of the expression typed in the similar field of second data source at reporting. The comparing will be applied after setting a relation by Main Expression. The equality of the expressions results will mean the relation of data elements of the first and the second source. If a data processing was chosen you can mark Compute with KeyValue in order to compute the values for data strings of the source ( field KeyValue ) instead of its documents.
•	Section Second Data Source;
	Sets the parameters for the second data source in the relation.
	•	Field Data Source;
		Choose name of a data source with which the relation from the first data source is being set.
	•	Field Data Processing;
		Choose name of a documents data processing in order to set the relation from its data strings instead of the documents of the data source.
	•	Field @ Main Expression;
		The expression is pasted into the left part of selection formula of the method NotesDatabase.Search before the equal sign "=" which will be called at reporting to select the documents for the second data source in the relation. For details see the description of the field in the section First Data Source above.
	•	Fields @ Add. Expressions ( 1 - 3 ) ( optional ).
		See description in the section First Data Source above.
•	Field Relation Name ( optional ).
	Type a name for the relation, if you plan to create more than one relation for the two data sources. A user can choose what relation he wants to apply in a report.