Add a new output column

To add a new output column for creating a report:

Note:For a list of all the database columns available in SimplyReports, see Database Columns

1. Select the Admin tab and select the SimplyReports content administration subtab.
2. Select the type of report in the Report types box.

The report output columns that apply to this type of report are listed in the Report output columns box.

3. Click Add to add another column to the list for that type of report.

The Table name lists and the Column name lists appear for the type of report.

4. Select the name of the database table that contains the data category in the Table name box, and select the name in the Column name box.
5. Type the name you want to display in the list box for that column in the Column name displayed in list box.
6. If you want the column name printed on the report to be different from the name displayed in this box, type a different name in the Column name printed on report box. You cannot enter spaces, but after the report is generated, you can change the column headings.

Tip:If the Column name printed on report box is left blank, the name of the column in the database (Column name) will be printed on the report.

7. Select a sort order for the column, Ascending or Descending.
8. Select from the following options:
• Select Displayed to technical users to make this database column available only to users designated as technical users.
• Select Displayed to normal usersto make this database column available only to users designated as normal users.
• Select both Displayed to technical users andDisplayed to normal users to make this database column available to both.

Note:For information on designating users as Normal or Technical users, see Setting Up SimplyReports Security.

9. Click Save to save the output column.