What is a PTR file?
To generate a report with PTReportGen, you must create a PTR file with a .ptr extension. The PTR file contains information such as the name of the report template file, the name of the report file, log file name, data sources, parameters and functions. The PTR file tells PTReportGen how to get data from data sources and how to put data into a report. Return to Top Return to Top What is a function? A function includes a SQL statement and some arguments. A function can be used to execute a SQL statement, and tell PTReportGen whether or how to add data into a report. Return to Top Return to Top How can I test a SQL statement? You can test SQL statements using Microsoft Query that is a component of Microsoft Office. You can find it under the installation directory of Microsoft Office. “C:\Program Files\Microsoft Office\OFFICE11\MSQRY32.EXE” Return to Top Return to Top When I execute a SQL statement, I receive an “ODBC driver does not support the requested properties.” error message. It pro
