Columns - Report Generator (Magic xpa 4.x)
The Columns step lets you select the variables you want to display, and their order, in the report table.
The left part of the screen shows the available columns, which includes all the fields selected in the Magic xpa program. The right part of the screen shows the columns you selected to be included in your report.
|
|
Special characters in the variable name will be replaced by a space.
The variable name cannot start with a number.
Variables with a name that begins with "X-" will not appear in the list.
When there are two (or more) variables with the same name, the following will occur:
-
If they appear on the form, they will not appear in the list.
-
If only one of them appears on the form, it will appear in the list. However, it will return the value of the first variable defined in the data view with the same name and not necessarily the one that appears on the form.
|
On the Columns screen you can perform the operations listed below:
-
Rename a column by clicking on the column, and then clicking the 
button. Enter a new name in the Column Properties dialog box and click OK.
Note: This only changes the column name for the current report.
-
Change the Date Format by marking a Date column you would like to change and pressing the button. You can edit the column name and change its date format in the Column Properties dialog box and click OK.
Note: The default format for Date columns is dd/mm/yyyy.
-
Select all columns by clicking the 
button.
-
Select a column by using one of the following methods:
-
Drag a column from the Available Items list to the Selected Items list.
-
Select a column and click the 
button.
-
Double-click on a column in the Available Items list.
-
Unselect all columns by clicking the 
button.
-
Unselect a column by marking the column and clicking the 
button.
-
Move a column up by marking it and clicking the 
button.
-
Move a column down by marking it and clicking the 
button.
