Edit a Report

- Once the report is created, clicking this button navigates the user directly to the Reports screen where the report can be run

ID - name of the flex report

  • This field is required

Title – the title which appears in the Report Title drop-down list on the Reports screen

Fix Column to Key On – the column that identifies which records generated by the report the Fix Sql code should process

Hidden Columns List – columns in the SQL code that should not appear in the grid

System Use Only – Super User only – flags report to not appear on the Reports screen

Use BackEnd Service – check this box in the cases where many rows will be returned to prevent TBS’s performance from being negatively affected

  • Only one report can be run at a time using the Back End Service

Description – the description of the report which appears on the Report

SQL – the SQL code that processes when the report is run

  • This field is required
  • See How to Add Parameters to SQL

Fix Sql – sql code to be processed either on all records returned by the report

This option adds a button to the Reports screen for the report.

Once the report is run and the results are displayed, this button can be clicked to run the Fix Sql code on:

  • All of the records

OR

  • Only records specifically selected by clicking the checkbox to their left