S/List User Manual To create a new S/List report:  | Select the NEW icon from the tool bar. | | Select the S/List Reports entry from the new entity window by either highlighting S/List Reports and clicking on OK or double-clicking on S/List Reports. This will open the S/List report wizard. |
Figure 11: New Entity window
 Alternative ways of creating a new S/List Report are:
| 1. Select the FILE menu and select New, then select S/List Report. | | 2. Hold down the CTRL key and press N to bring up new entity window, then select S/List Report. |
When you choose to create a report, it is recommended that you use the New Report Wizard. After completing the wizard, the report can be edited at any time. If at any point you do not decide to complete the wizard, click on the Cancel button, and confirm that you do not want to design a report.
SELECT TABLE
The first Report Wizard window dialog box that appears gives you a list of tables, and allows you to choose the table against which you will make the report. 
Figure 12: Table List dialog box
Highlight the table, then click on the Next button to progress to the dialog box following. Alternatively you can double-click on the table name to progress. 
Figure 13: Column Selection dialog box
The Available Columns list box contains a list of columns belonging to the table that you selected. Highlight a column from this list box and click on the Add button to include this column in the Selected Columns list box (i.e. the report). This action puts the column at the bottom of the Selected Columns list box. To undo a selection, highlight a column in the Selected Columns list box and click on the Remove button. When all of the columns in the Selected Columns list box are to your satisfaction, click on the OK button. The Add All and Remove All buttons adds all Available Columns to Selected Columns and reverts all Selected Columns to Available Columns respectively.
FORMAT OF COLUMNS
The third wizard dialog box allows you to define the format of each column you have chosen. 
Figure 14: Column Format dialog box
Note Column Format has (1 of 9) after it. This means you are at column one of the nine columns selected. Use the scroll bar to select the column. - | Contains the default display heading for the column, which can be edited. | - | The conversion to be used for each column can be defined if desired. Conversions are used to convert the column value to a different format. Examples include D to convert the internal date format to a readable date format; and B, which converts non-zeros and zeros to Yes and No Boolean values respectively. See Appendix A for the full list of conversion patterns. | - | The character width for each column can be defined, by typing in the number display width. | - | To change the Font you click on the  button once and here you can select the Font Type, Size and Style. | - | To select the % of shading you select the pull-down menu and choose the % of shading you require, you may also choose coloured shading. |
Table 2: Column Format dialog box fields  Note once you have selected a font style, type and size for your first column you only need to click on the button and click on the OK button, as the defined details will remain. Therefore you do not need to select the details again.
Do not click on the Next button when you want to make changes to columns, as this will only take you to the next Wizard dialog box and NOT the next column. 
Figure 15: Break Definition dialog box
If applying BREAK-ON or AVERAGE or TOTAL, remember that only one of these three break definitions can be chosen at the same time for a particular column. The LIMIT CLAUSE can only be applied to Multivalued fields. The table below briefly describes the operation of these fields: - | This puts a break in the report when the value of a column changes. You are allowed to have multiple break-on columns, if you wish. Break-on is used with columns that have been sorted. If more than one break-on is indicated, the report will break when the value of any one break-on column changes. Appendix A specifies how to use the Break-On line. An example of Break-On is a city field in an address record. If you have eight records with London as the city, and 4 records with Birmingham as the city, the report can display all Birmingham records together and all the London records will be shown together, on separate pages. (If the new page option is used.)
AVERAGE - Average is used for numeric columns; this is used to give an average, which is shown through the report. | - | Total is used for numeric columns and accumulates the value of each column being totalled; this is shown at the end of the report, and at any break points. | - | To add any Limit Clauses, select the button and a Define Limit Clause window comes up, as shown below. This limits the output of data from a Multivalue field to those values that meet a particular criterion. The advantage of Limit is it's of use when you wish to display merely a section of a Multivalue field. |
Table 3: Break Definition Fields
To obtain further details with regards to the above please refer to the OpenInsight Programmers Reference Manual, Appendix A on Openlist Keyword Reference 
Figure 16: Limit Clause Definition dialog box
Here, you can change column settings by stating which data should be shown for that column. You can select any one of the comparisons shown in the list. If you select a comparison you will need to enter a value otherwise you will get an alert message. The comparison types available to you in the radio button list are in Appendix A of this manual. After selecting a column and the comparison operator, you must enter a value or values against which the column will be compared.
For most of the comparison operators, you will only be required to enter a single value. For the Between comparison operator, two values must be entered - the lower value first, then the upper value second.
Figure 17: Break Definition dialogue box II
Once you have done this press OK and you will notice the Limit Clause field is now filled with comparisons and value you selected. Note for some of the columns you will not have the option to add something in Limit Clause. This is because only multi-valued fields can have this option.
After defining these details, click on the Next button to progress to the dialog box following.
The fifth wizard dialog box allows the format of column header, page headers and footers. 
Figure 18:Column Header and Footer dialog box Here you can select the font for your column headings using the button to insert font type, style and size. Select the % of shading or colour\color through the Shading pull-down menu.
You can edit Header and Footer text fonts and insert text for the report. To insert font type, style and size you need to click on the button.
Header and Footer are optional. Once you have inserted Headers and Footer, click on the Next button to progress to the dialog box following.
DEFINE OPTIONS
This wizard window allows you to select more options to define view settings. These are: | Show report headings | | Draw a box around the report table | | Show column headings | | Draw a grid - which will separate row and column entries with grid lines | | Display keys - the record keys |
Figure 19: View Settings dialog box
The image demonstrates how each option will be displayed.
After choosing which options you require, click on the Next button to progress to the dialog box following.
DEFINE FORMATTING OPTIONS
Formatting options can be defined for this report. The report formatting options are: | Display data double-spaced; the lines in the report are double-spaced. | | Display data without full details involves DET-SUPP, which is used with Total or Average. The values are printed at the end of the report, and at any breakpoint. The detail about each row is suppressed and only the Total, Average, Sub-Average or Sub-Total is printed. This is used when sorting BY and BREAKING-ON. To check this box, you will need to insert Break-On options in a Column and go to the Report Headings tab. You can then tick 'Display data without full details'. Please refer to Table 2 on page 16; this gives you Break-On options, which you can select. When you run the report you will see the details that have been suppressed and you can only see the values such as Total, Average and so on. | | Display multi values together on same page if possible. | | Display a grand total for totalled columns; if you have allowed at least one column to have a total in it's break details, then this checkbox will be available. The grand total will be displayed at the end of the report. Grand total options are explained in Appendix A. |
The report has a default font of Courier, (whose style is Regular and size is ten). The default font can be changed via the Report Font Options. This is done the same way as you have done previously by clicking on the button and selecting the style, size and font type. 
Figure 20: Report Formatting Options
DEFINE OUTPUT OPTIONS
This wizard dialog box defines Output Options for your report. This relates to:
Figure 21: Report Printing Options
This window dialog box allows you to enter the name of your report and its description. You can use this report in conjunction with either an S/List Query (select a Query Name from the pull-down menu) or you can enter a list of keys yourself (in the Key List text box).
Figure 22: Report Details and Query Type
After you have entered the report and query details, click on the Next button to progress to the dialog box following. 
Figure 23:Finish and Save dialog box
Once you are in the finished defining your report, the wizard window above will come up. To save the report, click on the Finish button.
When you click on the Finish button the window below will come up and notice you can still edit your report even after you have come out of Wizard. This will be discussed in detail at a later stage.
Figure 24: Editing dialog box
HOW TO TEST RUN THE REPORT
If you wish to test run the report you can do the following:
Figure 25: Running S/List Reports
Alternatively you can either select the File menu then click on Run Report or you can hold down the CTRL key and press R. Note if you change your mind about running the report you can click on the Stop icon to stop the process. Once the Run icon has been selected, S/List will select the records and initialise the report. 
Figure 26: Print Preview window
This shows a print preview of the report - the Print icon allows you to print the report. The preview size can be determined from the pull down menu, or you can manually enter the scale of the preview size (10% - 400%) For multiple paged reports, use the arrows to navigate the pages.
[top]
Editing Reports There are two situations where you can edit reports: | 1. Once you have completed the report creation wizard, you are brought to the report properties dialog box of the report that you have just created and saved. |
2. Click on the Open icon in the S/List workspace to open the Open dialog box. Then choose the report by its name to view the report properties dialog box.
Figure 27: Report Details dialogue box
The top half of the tab shows the table name and report description, the bottom half of the table allows you to build your report from either the result of a query (Use Query) or a list of record keys (Use Keys) that you wish to report on. If you use a query, a pull down menu lists the queries available.
Figure 28: Column I
This tab allows you to edit the format of report columns. You can highlight a column name and click on Add or Remove. If you wish to reorder the columns clicking on the Reorder button can do this. Another window is displayed showing a list of all the columns selected. You can highlight the first column name you would like displayed and click on the Add button. If you would like to remove one of the columns you have reordered you can click on the Remove button and this column name will be displayed back to the current order.
Amendments can be made to Conversion, Length, Justification, Font and Shading for each column.
Figure 29: Column II
Column II allows you to make amendments to Break-On, Average, or Total. Changes can be made in Limit Clause for columns that are multi-valued. To edit a column, highlight the column name on the left, then view the break-on details on the right.
Figure 30: Report Headings
This window has the entire Header and Footer, Column Heading and Data Formatting Option details, which can be changed. The Report Font is the default font for the report. If this is empty, then the size ten Courier font will be used. The Data Formatting Options show display options, including the Grand Total, whose options are detailed in Appendix A.
Figure 31: Output Format
This window allows you to edit the visual settings of the report. An image is shown indicating what kind of changes will be made in the report, if you select particular options. [top]
Printing Reports If you wish to print the report you can do this two ways. The first is to look at the Output Format tab and set the report destination to printer or you can run the report. To run the report you need to click on the Run icon at the menu bar. The window below comes up and the report is displayed on the terminal. To print this you need to click on the Print icon as shown below.
Figure 32: Print Preview window
PRINT SETTINGS
If you wish to change print settings to your report, you can do this by coming out of the print preview window and select File, Print Setup. Change the settings as required and to print the report go back to the print preview window and click on the Printer icon.  [top]
| 
