Track database contains a table called Reports which is used to store all the necessary information to generate a Crystal Report from the Track application. Track Report Wizard automatically populates this table with the required information. The following table is an explanation of the data stored and how it is used.
Column |
Data Type |
Description |
Report_Id |
Int |
Next sequential number assigned to a report. |
Name |
Varchar (100) |
The “user-friendly” name given to a report that will be displayed in the Report drop-down list. |
Filename |
Varchar (255) |
Name of the Crystal Report file. |
Flags |
Varchar (28) |
Switches used to enable or disable each selection option on the Reports screen. |
Filter |
Text |
Criteria used by Crystal Reports from the SQL query to select data based on the selection options available for the report. |
Description |
Varchar (255) |
Description of the report that is displayed as a tool-tip. |
Label_Text |
Varchar (500) |
Name of label assigned to a selection option. |