The Adhoc Reporting System within EMS is extremely flexible; from printing a single record to printing complicated regulatory reports, it provides an easy-to-learn interface that enables users to retrieve data from the system without difficulty.
At the simplest, a user may print the record they are looking at by just clicking the Print button. What they see on the screen will be printed.
If the user wishes to select specific fields to print on a report, they may use EMS’s built-in ad hoc reporting tool, Management Reports. Within the Management Reports module, we have grouped together tables that are connected to each other in the database and that would logically be used together for reporting certain kinds of data. This allows the user to create reports by just selecting a group of tables without having to know any SQL language.
The Management Report module allows the user to customize the appearance of the report, changing colors, font sizes and styles, putting borders around a single cell or an entire page, and totaling numeric columns.
Once a Management Report has been created, it may be cloned for use in creating a new report. The results of any Management Report can also be exported as an Excel spreadsheet, a PDF file, or a text file.
For reports that are more complicated, Crystal Reports 8.5 is used. Chemical Safety can create a report for the organization, or EMS users can create their own reports. Once a Crystal Report is saved in the reports folder, all EMS users can view it without any special software. Crystal reports may feature multiple sub-queries, and may be created to prompt the person running the report for specific data before generating the report.
