Change a Universe’s Data Connection without using the Universe COM SDK. Continue reading
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. Continue reading
Create a Crystal Report that dynamically recalculate its labels based on the Workstation’s localization settings.
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.
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. Continue reading
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.
Sort an array of numbers using the Shell sort algorythm. This sorting algorythm will quickly sort arrays in Crystal Reports.
This document discusses the syntax requirements for SQL Expression fields.
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.”
Information Systems Operations Services
General Mills, Inc.
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.