VisionCore
Home Search Support Forum Knowledge Base Print

Report Script

With the Report Script, you can create new report query or modify/edit query that is used to filter data by specifying conditions.

 

SQL Script Tab

In this tab, you can set the Name and Description of the report script/query, which will server as a reference ID for the particular script/query.  In the SQL Query Statement area, you can create or modify report query to be used in specifying conditions when filtering data.

 

Data Preview Tab

The Data Preview tab will display whether there are existing data for the selected report.

 

Info Note:  To be able t display data existing for the selected report, you have to click first the Execute button at top of this form.

 

Toolbar Buttons

Toolbar Buttons perform an action on the current record like adding, deleting or saving.

Bullet PointThe New button will will clear the form to allow a new report script or query to be added.

Bullet PointThe Save button will save the selected record.

Bullet PointThe Find button will enable you to Find script or query.

Bullet PointThe Delete button will delete the selected script or query.

Bullet PointThe Undo button will cancel out the last change/s done to the record reverting it to its older state.

Bullet PointThe Execute button will run the script or query entered.  This will then display the existing data in the Data Preview tab as specified in the SQL Query Statement area.

Bullet PointThe Close button will close the Report Script form.

 

Press F1 or click F1-Help button in the Status bar for help on how to use the Report Script form.

 


Related Topic

Special Case Datasources