TIMSS 6: Report of Your Custom Reports

On of the many niceties of TIMSS 6 is the ability incorporate your own Crystal Reports into the application. If you name them consistently, you can create a report to list all of the reports you've added to TIMSS.

My naming scheme has been to name them with the 3 letter module plus a number starting with 8000. For example MTG8007.

In a Crystal Report, you can find these by looking for an 8 as the 4 character and making sure that the length is greater than 6 (to exclude things like FAR800). The filter in Crystal would look like:

InStr ({TRS_APPLICATION.APPLICATION},'8') = 4 and Length ({TRS_APPLICATION.APPLICATION})>6

If you are the only user adding reports, you might use the ADDOPER to find your custom reports.

The data for the reports can be found in 3 tables:

1. TRS_APPLICATION- has APPLICATION_TYPE_CODE (CRYSTAL/BATCH), HELP_TEXT, SUBMIT_TYPE_CODE (ONLINE/BATCH)
2. TRS_APPLICATION_LINK- has APPLICATION for the screen it's linked to (you will need an outer join to include the TRS reports as they aren't linked to screens)
3. SEC_APPLICATION- has APPLICATION_DESCR as the short name of the report

My report shows the application, name, report type, help text, and the screen it's linked to.

Applies to: TIMSS6