Announcement: Easily integrate Crystal Reports with Remedy with UFLTimeZone for Crystal Reports

For Immediate Release

Monday, June 17, 2002 - Cogniza is proud to announce the release of UFLTimeZone for Crystal Reports. UFLTimeZone for Crystal Reports provides date and time zone conversion functions that gives new options when using Crystal Reports with Remedy's Action Request (AR) System. To understand the value of this new product, some background on Remedy is appropriate.

Background
Remedy AR System, from Peregrine Systems, stores dates in 'Epoch date' format. An Epoch date is the number of elapsed seconds since January 1, 1970 at Midnight Greenwich Mean Time. To provide a more human-understandable value, the Remedy ODBC driver converts this value to the familiar date and time format, using the user's regional settings, including time zone and seasonal adjustments (e.g. Daylight Savings).

Challenges
One of the challenges for developers, however, when working with Remedy's AR System is the one-table-per-query restriction imposed by the Remedy ODBC driver. When working with Crystal Reports and Remedy, this restriction prevents more that one table or view from being used in a report.

To address this issue when using Crystal Reports within the Remedy client, developers use sub-reports or request that the Remedy System Administrator creating a join table in the Remedy database. These solutions, while addressing the immediate need, lead to decreased database and report performance, increased report development time and increased demands on the Remedy System Administrator's time. Fortunately, there is another solution to these challenges!

Solutions
UFLTimeZone for Crystal Reports provides the same Epoch date and time zone conversion functions as the Remedy ODBC driver, but without the restrictions. By using UFLTimeZone for Crystal Reports in conjunction with a non-restrictive database driver, one can:
* Use the latest version of Crystal Reports

• Run reports externally from the Remedy client

Value
UFLTimeZone for Crystal Reports will increase productivity and lower costs by:
* Making developers more productive

• Decreasing report development time
• Decreasing the demands on the Remedy System Administrator's time

Download
To download a 30-day-trial version of UFLTimeZone for Crystal Reports, visit http://www.cogniza.com/products/UFLTimeZoneW_30.exe.

Coming soon, UFLTimeZone for Crystal Enterprise!

About Cogniza
Founded in 1996, Cogniza is a US company, headquartered in Minneapolis, Minnesota. We focus on providing consulting and software solutions to the IT Systems and Service Management community. Our solutions include ITSM consulting, business-intelligence-application integration and programmatical components. For more information, visit http://www.cogniza.com. Received on Mon Jun 17 2002 - 16:18:44 CDT