Reporting Module for Event Scheduling

Higher Education Software Industry

Client produces a 3-tier client server software product used by universities for scheduling classes, staff and functions that interfaces with student information systems, like PeopleSoft. The product had a few internal reports that were mostly inaccurate. Users wanted better reporting capabilities using Crystal Reports. Database support included Oracle, SQL Server, DB2, Sybase, Informix & Compuware’s Solid DB. Designed & developed a reporting GUI that:

• Allowed for integration of custom reports & selection parameters
• Ability to manage personal reports
• Provided over 50 reports to be shipped with the product
• Used the client's product's internal query engines to process data for enhanced performance
• Allowed for enforcement of user based security.
• Supported installation on several OS platforms and databases

Crystal reports to be shipped with the software included multiple data groups and sub-reports with parameters and formulas to pass calculated data between the main report & sub-reports; formulas to convert date and Boolean values to comply with all supported ODBC databases; formulas to retrieve data via date criteria where no actual date value existed, but was implied.

J2EE
Java Servlets
Java Beans
Javascript

Microsoft
Visual Basic
.Net
.asp

Php
Perl
html
Dhtml

MySQL
Postgres
Oracle
SQL Serve