It can be difficult for an application vendor to predict all the different ways that any one production site might want to report on its customized set of application data records. Therefore, the production site might have to write its own reports using either ABL or SQL.
The general process is as follows:
1. If the vendor has supplied template queries, determine whether one of those is close to what is needed.
2. Based on the audit data being collected through the audit policies in effect, use the vendor or OpenEdge schema information to create or customize the database query. For details about the OpenEdge schema, see Audit Data Tables.
3. Write the query and data presentation.
4. Test and debug.
Note: Be aware that if the report is for a government auditor, you might have to certify the truthfulness and trustworthiness of your report generator.
For more information about writing custom audit reports, see OpenEdge Development: Programming Interfaces.
