APTS should contain an ability to report on the data collected. One way APTS does this is through the use of a Report Designer utility I designed. This utility allows the user to select the fields they want to use in their report. This data is contained in the 2 tables which contain most of the data collected from the service calls. The user may select the column, sort order, column width, enter the column title and column alignment. The user may also select the Font size to use for the output. There is also an option to output to Excel. Included on this screen is user selected criteria so the report will select the facility, customer, date ranges, part, etc. There are many more criteria available. When the user is finished designing the report it may be displayed, then modifications made then displayed again. When the report is exactly what the user wants the report can then be named, a description entered and saved for use later by the user or by other users if desired. A report may also be recalled, modified and saved again.
There are many other "hard coded" reports available for the users, most of these reports have user selected criteria. A problem with any reporting via a Browser and a large database is the time required to "download" the completed report, they can be hundreds of pages many times. I solved that problem a few years ago when I created a series of reusable ASP subroutines. These subroutines allow me to create a new hard coded report very quickly, usually a few hours. However, the big advantage in using these subroutines is that they create a large report with as many pages of HTML as is necessary.
I have created approximately 1500 pages of report from a database in less than 2 minutes. These subroutines also create a series of "clickable index" pages so that the user can quickly navigate through the total report very quickly. I also provide a "print" link on each report page so that the frame containing the report may be printed simply by clicking this link.
Another set of reports shows what is "currently" going on in APTS, what service calls have been entered, what was done, where, by whom, when, etc. Also, more detail can be displayed in a portion of the screen and from there a detailed report may be display simply by clicking a link. This gives the 24/7 room the ability to monitor what is happening in "real time".
A great day-to-day management tool.