Report Writer > Create Report > RW Multiple Column Selection

RW Multiple Column Selection

You use this program to add multiple columns to sub elements of the Layout element of a Report Writer report (see Create Report).

This enables you to quickly define the columns you require in the report.

Multiple Column Selection

This screen enables you to select the column(s) you want to add to the report from a listview.

You can use Ctrl+F1 to access the available functions in this listview.

Field Description
Available Columns This listview displays all the columns contained in the primary and linked tables defined for the report as well as the user defined variables defined in the report.
> Select this to add the highlighted column(s) in the Available Columns listview to the Selected Columns listview.
< Select this to remove the highlighted column(s) from the Selected Columns listview.
>> Select this to add all the columns in the Available Columns listview to the Selected Columns listview.
<< Select this to remove all the columns from the Selected Columns listview.
Selected Columns

This listview displays the columns you have selected to add to the report.

You can use your mouse pointer to drag and drop (rearrange) the columns into the required sequence.
OK Select this to add the columns in the Selected Columns listview to the report.
Cancel Select this to return to the program without accepting any changes you made.

Add multiple columns to a report

  1. From the Create Report program, highlight the Layout sub element to which you want to add the columns.

    This sub element can be one of the following:

    • Page Heading
    • Group Level 1 -5 (under Group Heading)
    • Detail
    • Subtotal Level 1 -5
    • Report Total

  2. Move your mouse pointer to the listview and typically use your right mouse pointer to display the available options.

    The listview is the bottom right pane in the Tri-pane window.

  3. Select the Add Multiple Columns option.

    The screen of the RW Multiple Column Selection program is displayed.

  4. From the Available Columns listview of the RW Multiple Column Selection program, highlight the column(s) you want to add to the sub element.

  5. Select '>' to move the columns to the Selected Columns listview.

  6. Optionally use your mouse pointer to rearrange the sequence of the columns in the Selected Columns listview. You can use the drag and drop facility to do this.

  7. Select OK to add the columns in the Selected Columns listview to the sub element of your report.