Basic Principles to Create a Designer Report

There are a few basic principles that apply to all reports that you edit using the TMS Report Designer application.

• Only use Views (such as vWorkOrders) rather than Tables (such as tblWorkOrders).
• Use views that begin with a v (again, such as vWorkOrders) rather than vtbl.
• Use the following user information when creating a connection string:

• User Name: TMSREPORT

• Password: 4Rivers

• Adhoc reports do not contain WHERE clauses.
• Complete reports should contain WHERE clauses.
• All report file names must use the.XML extension.
• VBScript can be added to the OnPrint and OnFormat sections of the report for conditional formatting. (The VBScript format is in the standard If..Then_Else_End If format.)
• Multiple VBScript entries can be added to the same OnPrint section.

• The report must be named Main.