Change a Universe’s Data Connection without using the Universe COM SDK. (more…)

BusinessObjects-SDK · Programming · VB.Net

Use the BusinessObjects SDK to copy files between two InfoObjects. This is useful when the source is a ‘template’ object (e.g. Crystal Report) that will be deployed to one or more targets. (more…)

BusinessObjects-SDK · Programming · VB.Net

Create a Crystal Report that dynamically recalculate its labels based on the Workstation’s localization settings.

(more…)

Business Objects Enterprise · Crystal Reports · Localization

Often it is desirable to display a message, such as ‘No matching records’, when a report does not contain data. Unfortunately, Crystal Reports does not have a function to easily identify this state.

(more…)

Business Objects · Crystal Reports · Technique

The location of the Crystal Reports ‘Shared’ directory has changed over time. When deploying applications that use Crystal Reports, ensure that exporting, user-function library (UFL), and database DLLs are located in the appropriate directory for the version of Crystal Reports that is being used. (more…)

Business Objects · Crystal Reports

Add a dynamic, date-range parameter to a report which includes the most recent 12 months, plus Crystal Reports’ Month-to-Date and Year-to-Date ranges.

(more…)

Business Objects · Business View · Crystal Reports · Date/Time · Parameters · SQL Server

Sort an array of numbers using the Shell sort algorythm. This sorting algorythm will quickly sort arrays in Crystal Reports.

(more…)

Business Objects · Crystal Reports · Functions · Programming

This document discusses the syntax requirements for SQL Expression fields.

(more…)

Crystal Reports · SQL

General Mills Case Study

“We had four developers with four ways of converting Remedy date storage format to human readable format. None worked properly.”

“The Cogniza UFLTimeZone functions immediately solved the problem. We were fixing all reports Remedy date fields with every spring into daylight savings and fall coming out.”

“With over 130 reports with Remedy dates, UFLTimeZone paid for itself after as soon as all the reports were converted; within a month, daylight savings ended (and summer time in the UK) and we didn’t have to tweek any of the reports.”

“Users noticed right away. They had gotton use to wrong reports for a couple weeks until developers could work through fixing all reports.”

“Within weeks of converting to using Cogniza’s UFLTimeZone for Crystal Reports, other internal developers of Crystal Reports noticed we solved our problem and asked to use the functions too.”

“I’d recommend UFLTimeZone for Crystal Reports to anyone struggling with the limitiations of the Remedy ODBC driver or those frustrated with trying to convert dates by using Crystal formulas.”

Gary Ledo
Program Manager
Information Systems Operations Services
General Mills, Inc.

No tags

For Immediate Release

Monday, June 17, 2002 – Cogniza announces the release of UFLTimeZone for Crystal Reports. UFLTimeZone for Crystal Reports provides date and time zone conversion functions that give 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.

(more…)

Business Objects · Crystal Reports · Date/Time · Remedy ARS · Timezone · UFL