Create a Custom Report
TrackPro includes a powerful Report Designer that permits you to design custom reports. Prior to creating your own report it is advisable to do a quick review of the FastReports Manual. You can download the manual from:
https://www.Baronsoftware.com/TrackPro.php

|
Warning:The Report Designer in TrackPro is a complex tool intended for IT specialists. It requires some basic SQL knowledge.
|
The basic procedure is as follows:
- Open the Report Designer.
- Choose a report that is similar in appearance to the one you want to create.
- Open the report file located in the TrackPro Data folder.
- Immediately save the file under a new name.
- Go to the "Data" tab. Select the ADO query shown in the large white area of the form.
- If required, modify the ADO query. See the manual for syntax requirements.
- In the properties window select SQL and click on the right side to open the sub window.
- Modify the query as necessary.
- Save the query.
- Switch to the the "Page1"
- Modify the displayed fields, fonts, and/or spacing as desired.
- Save the report and run it from the reports screen.

|
Tip: Here are some tips for modifying the queries.
- Enclose string search criteria in single quotes.
- Do not enclose numeric search criteria in quotes.
- Case does not matter.
- Enclose field names in brackets (the brackets are not necessary if there is no space in the field name, however it is best to use them for readability).
|