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:
- 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.
|