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

On the tab Export of Data of a report properties document you can set up the export properties for data created at a reporting. A data export can be done for the purpose of their viewing, editing or storing in a file. In the application are available the three export types into file: with using the program MS Excel, the program component Tidestone F1 and HTML. On the tab are set up properties for all three types.

• Fields @ Folder and File Name;

Type into each of two fields an expression in Formula Language to compute the full file name at local reporting for the cases when file saving is required. Such cases are: the applying a file with table template ( folder only ), export of data of several reports into an one file, a exporting into HTML. Type a text in commas, for example "my_report", or type an expression in Formula Language to compute the text, for example "my_report_" + @Text( @Today ). If file name does not contain an extension it will be added depending on export type. If you experience a difficulty, contact the application administrator.

• Option Transform formulas to export format;

This matters only if in the report are computed totals or/and the report has computed columns. Check the option to keep formulas in the report table and to transform them to the format of a program to which report data are exported. If the option hasn't been checked ( by default ), the columns values will be exported. Below define the combinations of rows and columns of the report to which the option will be applied.

• Option Separate rows for first level's totals in bottom;

Check the option to display the columns of a row with subtotals of the first level by separate row below data. By default all subtotals in a data table are displayed above data.

• List Move in totals row the columns;

Choose or type the numbers of columns to move them into bottom subtotals row.

• Option Keep the columns when moving;

Choose or type the numbers of columns which should be displayed at the same time in top and bottom subtotals rows.

• Fields Paste text into column;

Type a text and number of a column ( in a bottom subtotals row ) which the specified text will be pasted into.

• Option Row color.

Choose a color for the bottom subtotals rows.

Section Filling Empty in Table;

The options in the section set up filling empty cells in a table row with values of other cells what may improve the view of table. The option affects only cells whose emptiness is result of column absence for a data source used in the row.

• Option Merge single row in group with group's row;

Check the option to merge the single data row in a group with the row of the group in table. The option allows to reduce count of rows in data table. Below specify the list of data sources and their groups to which the option should be applied.

• Option Fill empty cells by values from above;

Check the option to fill the empty cells in a column of data table by value from the first nonempty cell that is placed above in the column.

• Option Fill empty cells by values from left;

Check the option to fill the empty cells in a row of data table by value from the first nonempty cell that is placed at the left in the row.

For the last two options in the section choose a method of filling empty cells for the each option. The method Merge Cells (by default) means that a empty cell will be filled up through merging with a filled cell, the method Copy Cells - through copying the one.

For all three options in the section you can define the list of data sources and their groups which the option will be applied to.

Section Table Settings;

In the section you can set up the properties for the table of report data.

• Option Use Template for Table;

Check to apply the properties of a template to the table of report data at a exporting. The template may be a table of the format MS Excel (.xls) or Tidestone F1 (.vts). The template will not be applied when exporting to HTML. Attach a file with template in the field Tempate File. A file of the format MS Excel (.xls) can be used for the both export types, but a file of the format Tidestone F1 (.vts) for exporting to Tidestone F1 only. For temporary placing the template file on disk will be used the folder specified in the first field of the group Folder and File Name above.

• Option Insert report name before data;

This matters only if you don't use a table template. Check to paste the report name into the row above the header of data table.

• Section Data Table.

Type in the fields The First Row and The First Column a row number and a column number which will become the first for report data in table. Thus, you can move report data down or/and to the right in table. In the field Max Columns Count type a number if you want to restrict the columns count in table from the first one at the left. The number 0 (by default) means export of all report columns.

Section Pasting Text into Table.

In the section you can set up the properties for pasting a text into various areas of table after its filling with report data. A text can contain computing tags. Press the button New Text to add a text for pasting.

• Option Pasting Method;

Choose how the text will be pasted into table.

• Choice Replacing Text in Table;

Choose the method to find a text in all table and replace it. Type into the field Find Text a text which will be found and replaced.

• Choice Specify Cell;

Choose the method to paste the text into a cell by its row and column number in relation to beginning of table. Type into the fields Row Number and Column Number the two numbers.

• Choice Specify Cell in Bottom.

Choose the method to paste the text into a cell by its row number in relation to the last row with report data and by its column number in relation to beginning of table. Type into the field Row Number and Column Number the two numbers. The number 0 in the field Row Number means the last row with report data in table.

• Option Text Type;

Choose what text will be pasted into table.

• Choice Text with Tags;

Means the pasting a text which can contain computing tags.

• Choice Formula of Export Program;

Means the pasting a formula in the format of an export program. Use the format R[1]C[1] for MS Excel and R1C1 for Tidestone F1 with the symbol "=" at the beginning. If you have chosen Specify Cell at the Bottom in the option Pasting Method, a formula will be computed in relation to the last row with report data.

• Choice @ Formula.

Means the pasting the result of computing an expression in Formula Language. Type the expression below.

• Field Text for Pasting;

Type a text according to the type chosen above. For the type Text with Tags you can choose tags from the list Tags, to append a chosen one to the text press the button Append Tag. The tags in the text will be computed at a text pasting into table.

To add the done setting to the settings list of text pasting, press the button Add to Settings. To cancel it, press the button Cancel.

• List Settings for Text Pasting.

The list contains all done settings for pasting of text into table. A row in the list contains the setting in either of four formats:

The replacing a text in table
0 | text to find | expression

The pasting a value into cell in relation to beginning of table
1 | row number | column number | expression

The pasting a value into cell in relation to last data row in table
2 | row number | column number | expression

The deleting of rows # i, j, ... and columns # n, m, ... in table
3 | Ri Rj ... Cn Cm ... | expression

Where expression for all types of paste except the type Formula of Export Program means an expression in Formula Language. By default an expression is being computed on the header of data table but you can type the extended format Rx expression, where Rx means the using of column values of data row with sequence number x ( R1 - the first row, R2 - the second row etc. ). To use in an expression the value of column with sequence number y type in the expression the field name with the column value - Cy ( C1 - the first column, C2 - the second column etc. ). In the case of the deleting of rows / columns an expression must be an condition with computed result @True (1) to perform the deleting.

You can change or delete a setting in the list. If you experience a difficulty, contact the application administrator.

•	Fields @ Folder and File Name;
	Type into each of two fields an expression in Formula Language to compute the full file name at local reporting for the cases when file saving is required. Such cases are: the applying a file with table template ( folder only ), export of data of several reports into an one file, a exporting into HTML. Type a text in commas, for example "my_report", or type an expression in Formula Language to compute the text, for example "my_report_" + @Text( @Today ). If file name does not contain an extension it will be added depending on export type. If you experience a difficulty, contact the application administrator.
•	Option Transform formulas to export format;
	This matters only if in the report are computed totals or/and the report has computed columns. Check the option to keep formulas in the report table and to transform them to the format of a program to which report data are exported. If the option hasn't been checked ( by default ), the columns values will be exported. Below define the combinations of rows and columns of the report to which the option will be applied.
•	Option Separate rows for first level's totals in bottom;
	Check the option to display the columns of a row with subtotals of the first level by separate row below data. By default all subtotals in a data table are displayed above data.
	•	List Move in totals row the columns;
		Choose or type the numbers of columns to move them into bottom subtotals row.
	•	Option Keep the columns when moving;
		Choose or type the numbers of columns which should be displayed at the same time in top and bottom subtotals rows.
	•	Fields Paste text into column;
		Type a text and number of a column ( in a bottom subtotals row ) which the specified text will be pasted into.
	•	Option Row color.
		Choose a color for the bottom subtotals rows.

•	Option Merge single row in group with group's row;
	Check the option to merge the single data row in a group with the row of the group in table. The option allows to reduce count of rows in data table. Below specify the list of data sources and their groups to which the option should be applied.
•	Option Fill empty cells by values from above;
	Check the option to fill the empty cells in a column of data table by value from the first nonempty cell that is placed above in the column.
•	Option Fill empty cells by values from left;
	Check the option to fill the empty cells in a row of data table by value from the first nonempty cell that is placed at the left in the row.

•	Option Use Template for Table;
	Check to apply the properties of a template to the table of report data at a exporting. The template may be a table of the format MS Excel (.xls) or Tidestone F1 (.vts). The template will not be applied when exporting to HTML. Attach a file with template in the field Tempate File. A file of the format MS Excel (.xls) can be used for the both export types, but a file of the format Tidestone F1 (.vts) for exporting to Tidestone F1 only. For temporary placing the template file on disk will be used the folder specified in the first field of the group Folder and File Name above.
•	Option Insert report name before data;
	This matters only if you don't use a table template. Check to paste the report name into the row above the header of data table.
•	Section Data Table.
	Type in the fields The First Row and The First Column a row number and a column number which will become the first for report data in table. Thus, you can move report data down or/and to the right in table. In the field Max Columns Count type a number if you want to restrict the columns count in table from the first one at the left. The number 0 (by default) means export of all report columns.

•	Option Pasting Method;
	Choose how the text will be pasted into table.
	•	Choice Replacing Text in Table;
		Choose the method to find a text in all table and replace it. Type into the field Find Text a text which will be found and replaced.
	•	Choice Specify Cell;
		Choose the method to paste the text into a cell by its row and column number in relation to beginning of table. Type into the fields Row Number and Column Number the two numbers.
	•	Choice Specify Cell in Bottom.
		Choose the method to paste the text into a cell by its row number in relation to the last row with report data and by its column number in relation to beginning of table. Type into the field Row Number and Column Number the two numbers. The number 0 in the field Row Number means the last row with report data in table.
•	Option Text Type;
	Choose what text will be pasted into table.
	•	Choice Text with Tags;
		Means the pasting a text which can contain computing tags.
	•	Choice Formula of Export Program;
		Means the pasting a formula in the format of an export program. Use the format R[1]C[1] for MS Excel and R1C1 for Tidestone F1 with the symbol "=" at the beginning. If you have chosen Specify Cell at the Bottom in the option Pasting Method, a formula will be computed in relation to the last row with report data.
	•	Choice @ Formula.
		Means the pasting the result of computing an expression in Formula Language. Type the expression below.
•	Field Text for Pasting;
	Type a text according to the type chosen above. For the type Text with Tags you can choose tags from the list Tags, to append a chosen one to the text press the button Append Tag. The tags in the text will be computed at a text pasting into table.
	To add the done setting to the settings list of text pasting, press the button Add to Settings. To cancel it, press the button Cancel.
•	List Settings for Text Pasting.
	The list contains all done settings for pasting of text into table. A row in the list contains the setting in either of four formats:
	The replacing a text in table 0 \| text to find \| expression
	The pasting a value into cell in relation to beginning of table 1 \| row number \| column number \| expression
	The pasting a value into cell in relation to last data row in table 2 \| row number \| column number \| expression
	The deleting of rows # i, j, ... and columns # n, m, ... in table 3 \| Ri Rj ... Cn Cm ... \| expression
	Where expression for all types of paste except the type Formula of Export Program means an expression in Formula Language. By default an expression is being computed on the header of data table but you can type the extended format Rx expression, where Rx means the using of column values of data row with sequence number x ( R1 - the first row, R2 - the second row etc. ). To use in an expression the value of column with sequence number y type in the expression the field name with the column value - Cy ( C1 - the first column, C2 - the second column etc. ). In the case of the deleting of rows / columns an expression must be an condition with computed result @True (1) to perform the deleting.
	You can change or delete a setting in the list. If you experience a difficulty, contact the application administrator.