Reports Wizard: application for the reporting in IBM Lotus Notes. Help: Column of report

The properties for a report column you can set up in its properties document in the report structure. The properties document of a column is separated on the tabs: Main, Additionally, Totals, Color and Export.

Tab Main;

• Field Column Number;

Type a number as sequence number for the column in the report table. You can type more than one numbers separated with semicolon to apply the properties to several columns of the table at once.

• Field Column Name;

Type a text as the name for the column that can be displayed in the table header. It is possible not to fill the field at first but to copy to it the data source attribute name which you going to choose as the column value below.

• Option Computed Column;

Check the option to compute the column value using other ones in the table row or by another method. You should define the method of computing below.

• Option Type and Object of Applying;

Make a choice to define type and method of applying of typed formula below.

• Choice Numeric Operations with Table Columns;

Check the method to compute the column value using other ones in the table row with referencing by their numbers. As a reference use the format [n], where n is a column number. For example, [1] + [2] means the column value is the sum of values of the first and the second column in the report table. The relative referencing is allowed: [0] is the value of the current column, [0-n] is the value of column distant n ones from the current column to the left and similarly [0+n] to the right in the table row.

• Choice Formula of Export Program;

The formula will be pasted into a cell "as is" to compute its value in an export program. The syntax of the specified formula must match to an export program that will be chosen.

• Choice @ Formula with Table Columns;

Choose the method to compute the column value using other ones in the table row by applying an expression in Formula Language. The expression will be computed for the document Notes representing a table row of the report in the application Report Wizard. The value of a row column is contained in the document field with the name Cn, where n is the column number. For example, @Text( C1 + C2 ) + "abc" means the column value is sum of values of the first and the second column with converting the result to a text and then appending to it the string "abc".

• Choice @ Formula with Document Fields.

Choose the method to compute the column value using the fields' values of a database document. The expression in Formula Language will be computed for each of selected documents for the data source. Thus you should know the fields' names and their senses in a database document. Use the method in the absence of the suitable data source attribute which you would choose as the column value.

• Option Add dates of reporting period into fields D1 and D2;

It matters only if reporting period is applied and the method @ Formula with Table Columns is chosen. The both dates of start and of end of reporting period will be added into the fields D1 and D2 of the document representing a data row of report that you could use the dates to compute the column value. If the option is checked, in expression for the column except values of other row columns ( fields C1, C2, ... ) you also can use the dates of reporting period - field D1 and D2.

• Field Expression.

Type an expression to compute the column value according to chosen above method.

• Option Attribute;

This matters only if you haven't check Computing Column above. Choose an attribute of the data source to use it as the column value. The list of available attributes depends on settings done by the application administrator. After the choice has been done, you can press Add to Name just below in order to append the name of chosen attribute to the column name.

• List Column Only for Relations.

This matters only if the data source is related to more than one in the report structure. Also the column should not is computing, excepting the method @ Formula with Document Fields. The column value will be computed only for documents of the data source which have a relation to chosen here data sources.

Below on the tab you can set up values for attribute parameters if they are exist. The parameters can affect the result of computing the column value. At first choose a parameter and then set up a value for it. Availability of parameters for an attribute depends on settings done by the application administrator.

Tab Additionally;

• Option Group;

Check the option if you want to group table rows by value in the column. Multilevel nested rows' grouping is available. For creating group of each level can be used one or more columns of a data source. If a data source is related to other, group rows will be created under the row which the relation is set to. The rows of different data sources not related to other one or related to the same in the report structure will have the common groups in case their values are equal.

• Option Column Only for Group;

Check the option in order that the column value will be displayed only in the group but not in rows under the group in the table.

• Field Group Level;

Choose a level from 1 to 5 for the group. Each a next level will become nested for a previous one. You can choose the same level for more than one column of a data source if you want their values in the row to create the group.

• Option Group Color;

Choose a color for the group level if you want to mark visually group rows in table. If the same level is chosen for more than one column, to set a color in any one of them is enough.

• Option Don't create group if value in the column is equal to;

Check, if you don't want to create the group at certain values in the column of a data row of report. List the values of the column by one in new line below.

• Option Sort;

Check the option if you want to sort rows in table by the column values. For multiple nested sorting, check the option in more than one column of the data source. To the right choose Order for the sorting from Ascending and Descending.

• Option Use column values as dates of reporting period;

This matters only if the column isn't computing excepting the method @ Formula with Document Fields ( see option Computed Column on the tab Main ). Check the option if you want to check a column value for being in specified date range (reporting period). Only documents with the column value lying within the reporting period will be selected for the report. A value of the column should be a date. The common reporting period is set up on the tab Reporting Period of the report properties document but you can also set up special one for the column below.

• Option Use column values as dates of reporting period without adding column;

The option works like described one above but the column will not be placed into data table of report.

The described below options are available only if one of two described above options was checked.

• Option Select document when no date in the column;

Check if you want to select a document in the report in the absence of value in the column looking like date.

• Option Special Reporting Period.

Check the option if you want to apply a special reporting period for the column. The special period overwrites the common one. Choose dates in the fields Start Date and End Date for setting date range. The other options of the section are similar to that are presented on the tab Reporting Period of report properties document.

Tab Totals;

• Option Summarize for Data Sources and Groups;

Choose data sources names or their groups for whose rows you want to summarize the column values. You can choose from data sources which are in the relations chain beginning from the nearest to the first level in the report. The result of summing will be the column value in the row of the data source or of its group to which is set the relation at a reporting. Choose Total for common summing for the column with displaying the result in the last table row at the bottom. Further choose a summing method.

• Option Column Only for Calculation of Totals.

Check the option if you want to use the column only for the summing for related rows of other data sources and their groups but not to compute the values of the column in row of the data source which the column belongs to. It may reduce the time of a reporting.

• Option Type of Summing;

Defines how will be performed the summing for related rows of data sources and their groups chosen above.

• Choice Summarize as Number;

The method is default. Choose the method if you want to summarize the column values arithmetically. A column value should be either a number or a text representing a number. All another values will be summarized as zero.

• Choice Summarize into Text List;

Choose the method in order that the result of the summing will be a text list with column values. If a value is not a text, it will be converted to text for the summing.

• Choice Summarize as Text thru Separator;

Choose the method in order that the result of the summing will be a string with the column values separated by a symbol. Further in the field Separator choose such symbol.

For the both methods described above, you can check the option Unique Values in order to summarize only unique values of the column which are not yet contained in the result. If a value is already contained in the result, it will be skipped.

• Choice Calculate Mean Value;

Choose the method if you want to compute average from the column values. A value of the column should be either a number or a text representing a number. All another values will be summarized as zero.

• Choice Apply Formula;

This matters only if you have checked Computed Column and haven't chosen the method @ Formula with Document Fields on the tab Main. Instead of a summing of column values will be applied the expression to compute a column value using values of other columns in the summing row ( see field Formula on the tab Main ). The option allows applying the settings for computing of values of the column in the related row of other data sources or their groups, which you have chosen in the option Summarize for Data Sources and Groups.

• Choice Apply Condition for Color.

This matters only if you check the option Color on Condition on the tab Color. Instead of summing of the column values will be applied the conditions for setting up a color for the column in a summing row. The option allows applying the coloring settings of the column, specified in the tab Color, to related rows of other data sources or their groups which you have chosen in the option Summarize for Data Sources and Groups.

• List Propagate for Data Sources and Groups.

Choose the data sources and/or their groups whose data rows you want to propagate value of the column into. In the list are available only the data sources from which explicitly or thru cascade a relation in the report with the data source of the column has been set.

Tab Coloring;

• Option Color;

Choose a color for the column. The color will be applied to all row of the data source by default. If you use a table template ( see the tab Export of Data in report properties document ) defined column color in the template will be overwritten by chosen here.

• Option Color on Condition.

Check the option if you want to apply color to the column on a condition. Type up to 5 conditions using values of columns in a table row. Each following condition will be checked in case the result of previous one is False. If the result of any condition is True the conditions following it won't be checked. As reference to value of a column in a row use the format [n] where n is a column number. For example, [1] > [2] checks for condition that value of the first column exceeds the second. The relative referencing is allowed: [0] is the value of the current column, [0-n] is the value of column distant n ones from the current column to the left and similarly [0+n] to the right in the table row. You also can type here a condition in Formula Language, in this case as the reference to values of columns you should use names of fields of the document representing a table row of the report. A document field has the name Cn where n is a column number. For example, @Contains ( @Text ( �1 ); @Text ( C2 )) means checking the condition of finding value of the second column in the first with conversion of both values to the text.

Tab Export.

The most of the properties on the tab matter only if you don't use a table template ( see the tab Export of Data in report properties document ). In this case you can set up the table properties here: Width, Format, Aligning. Otherwise the properties of the column are defined by the ones in the row following the table header in the template.

Topic links:

Reporting Period ( report properties tab )

Export of Data ( report properties tab )

•	Field Column Number;
	Type a number as sequence number for the column in the report table. You can type more than one numbers separated with semicolon to apply the properties to several columns of the table at once.
•	Field Column Name;
	Type a text as the name for the column that can be displayed in the table header. It is possible not to fill the field at first but to copy to it the data source attribute name which you going to choose as the column value below.
•	Option Computed Column;
	Check the option to compute the column value using other ones in the table row or by another method. You should define the method of computing below.
	•	Option Type and Object of Applying;
		Make a choice to define type and method of applying of typed formula below.
		•	Choice Numeric Operations with Table Columns;
			Check the method to compute the column value using other ones in the table row with referencing by their numbers. As a reference use the format [n], where n is a column number. For example, [1] + [2] means the column value is the sum of values of the first and the second column in the report table. The relative referencing is allowed: [0] is the value of the current column, [0-n] is the value of column distant n ones from the current column to the left and similarly [0+n] to the right in the table row.
		•	Choice Formula of Export Program;
			The formula will be pasted into a cell "as is" to compute its value in an export program. The syntax of the specified formula must match to an export program that will be chosen.
		•	Choice @ Formula with Table Columns;
			Choose the method to compute the column value using other ones in the table row by applying an expression in Formula Language. The expression will be computed for the document Notes representing a table row of the report in the application Report Wizard. The value of a row column is contained in the document field with the name Cn, where n is the column number. For example, @Text( C1 + C2 ) + "abc" means the column value is sum of values of the first and the second column with converting the result to a text and then appending to it the string "abc".
		•	Choice @ Formula with Document Fields.
			Choose the method to compute the column value using the fields' values of a database document. The expression in Formula Language will be computed for each of selected documents for the data source. Thus you should know the fields' names and their senses in a database document. Use the method in the absence of the suitable data source attribute which you would choose as the column value.
	•	Option Add dates of reporting period into fields D1 and D2;
		It matters only if reporting period is applied and the method @ Formula with Table Columns is chosen. The both dates of start and of end of reporting period will be added into the fields D1 and D2 of the document representing a data row of report that you could use the dates to compute the column value. If the option is checked, in expression for the column except values of other row columns ( fields C1, C2, ... ) you also can use the dates of reporting period - field D1 and D2.
	•	Field Expression.
		Type an expression to compute the column value according to chosen above method.
•	Option Attribute;
	This matters only if you haven't check Computing Column above. Choose an attribute of the data source to use it as the column value. The list of available attributes depends on settings done by the application administrator. After the choice has been done, you can press Add to Name just below in order to append the name of chosen attribute to the column name.
•	List Column Only for Relations.
	This matters only if the data source is related to more than one in the report structure. Also the column should not is computing, excepting the method @ Formula with Document Fields. The column value will be computed only for documents of the data source which have a relation to chosen here data sources.

•	Option Group;
	Check the option if you want to group table rows by value in the column. Multilevel nested rows' grouping is available. For creating group of each level can be used one or more columns of a data source. If a data source is related to other, group rows will be created under the row which the relation is set to. The rows of different data sources not related to other one or related to the same in the report structure will have the common groups in case their values are equal.
	•	Option Column Only for Group;
		Check the option in order that the column value will be displayed only in the group but not in rows under the group in the table.
	•	Field Group Level;
		Choose a level from 1 to 5 for the group. Each a next level will become nested for a previous one. You can choose the same level for more than one column of a data source if you want their values in the row to create the group.
	•	Option Group Color;
		Choose a color for the group level if you want to mark visually group rows in table. If the same level is chosen for more than one column, to set a color in any one of them is enough.
	•	Option Don't create group if value in the column is equal to;
		Check, if you don't want to create the group at certain values in the column of a data row of report. List the values of the column by one in new line below.
•	Option Sort;
	Check the option if you want to sort rows in table by the column values. For multiple nested sorting, check the option in more than one column of the data source. To the right choose Order for the sorting from Ascending and Descending.
•	Option Use column values as dates of reporting period;
	This matters only if the column isn't computing excepting the method @ Formula with Document Fields ( see option Computed Column on the tab Main ). Check the option if you want to check a column value for being in specified date range (reporting period). Only documents with the column value lying within the reporting period will be selected for the report. A value of the column should be a date. The common reporting period is set up on the tab Reporting Period of the report properties document but you can also set up special one for the column below.
•	Option Use column values as dates of reporting period without adding column;
	The option works like described one above but the column will not be placed into data table of report.
	The described below options are available only if one of two described above options was checked.
	•	Option Select document when no date in the column;
		Check if you want to select a document in the report in the absence of value in the column looking like date.
	•	Option Special Reporting Period.
		Check the option if you want to apply a special reporting period for the column. The special period overwrites the common one. Choose dates in the fields Start Date and End Date for setting date range. The other options of the section are similar to that are presented on the tab Reporting Period of report properties document.

•	Option Summarize for Data Sources and Groups;
	Choose data sources names or their groups for whose rows you want to summarize the column values. You can choose from data sources which are in the relations chain beginning from the nearest to the first level in the report. The result of summing will be the column value in the row of the data source or of its group to which is set the relation at a reporting. Choose Total for common summing for the column with displaying the result in the last table row at the bottom. Further choose a summing method.
	•	Option Column Only for Calculation of Totals.
		Check the option if you want to use the column only for the summing for related rows of other data sources and their groups but not to compute the values of the column in row of the data source which the column belongs to. It may reduce the time of a reporting.
•	Option Type of Summing;
	Defines how will be performed the summing for related rows of data sources and their groups chosen above.
	•	Choice Summarize as Number;
		The method is default. Choose the method if you want to summarize the column values arithmetically. A column value should be either a number or a text representing a number. All another values will be summarized as zero.
	•	Choice Summarize into Text List;
		Choose the method in order that the result of the summing will be a text list with column values. If a value is not a text, it will be converted to text for the summing.
	•	Choice Summarize as Text thru Separator;
		Choose the method in order that the result of the summing will be a string with the column values separated by a symbol. Further in the field Separator choose such symbol.
		For the both methods described above, you can check the option Unique Values in order to summarize only unique values of the column which are not yet contained in the result. If a value is already contained in the result, it will be skipped.
	•	Choice Calculate Mean Value;
		Choose the method if you want to compute average from the column values. A value of the column should be either a number or a text representing a number. All another values will be summarized as zero.
	•	Choice Apply Formula;
		This matters only if you have checked Computed Column and haven't chosen the method @ Formula with Document Fields on the tab Main. Instead of a summing of column values will be applied the expression to compute a column value using values of other columns in the summing row ( see field Formula on the tab Main ). The option allows applying the settings for computing of values of the column in the related row of other data sources or their groups, which you have chosen in the option Summarize for Data Sources and Groups.
	•	Choice Apply Condition for Color.
		This matters only if you check the option Color on Condition on the tab Color. Instead of summing of the column values will be applied the conditions for setting up a color for the column in a summing row. The option allows applying the coloring settings of the column, specified in the tab Color, to related rows of other data sources or their groups which you have chosen in the option Summarize for Data Sources and Groups.
•	List Propagate for Data Sources and Groups.
	Choose the data sources and/or their groups whose data rows you want to propagate value of the column into. In the list are available only the data sources from which explicitly or thru cascade a relation in the report with the data source of the column has been set.

•	Option Color;
	Choose a color for the column. The color will be applied to all row of the data source by default. If you use a table template ( see the tab Export of Data in report properties document ) defined column color in the template will be overwritten by chosen here.
•	Option Color on Condition.
	Check the option if you want to apply color to the column on a condition. Type up to 5 conditions using values of columns in a table row. Each following condition will be checked in case the result of previous one is False. If the result of any condition is True the conditions following it won't be checked. As reference to value of a column in a row use the format [n] where n is a column number. For example, [1] > [2] checks for condition that value of the first column exceeds the second. The relative referencing is allowed: [0] is the value of the current column, [0-n] is the value of column distant n ones from the current column to the left and similarly [0+n] to the right in the table row. You also can type here a condition in Formula Language, in this case as the reference to values of columns you should use names of fields of the document representing a table row of the report. A document field has the name Cn where n is a column number. For example, @Contains ( @Text ( �1 ); @Text ( C2 )) means checking the condition of finding value of the second column in the first with conversion of both values to the text.