help

Create a Custom Report


General Topics > How to > 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/Products/TrackPro/other_downloads/27-fastreports-manual.html


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:

  1. Open the Report Designer.
  2. Choose a report that is similar in appearance to the one you want to create.
  3. Open the report file located in the TrackPro Data folder.
  4. Immediately save the file under a new name.
  5. Go to the "Data" tab. Select the ADO query shown in the large white area of the form.
  6. If required, modify the ADO query. See the manual for syntax requirements.
    1. In the properties window select SQL and click on the right side to open the sub window.
    2. Modify the query as necessary.
    3. Save the query.
  7. Switch to the the "Page1"
  8. Modify the displayed fields, fonts, and/or spacing as desired.
  9. 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).