Change a Universe’s Data Connection without using the Universe COM SDK. Continue reading
Category Archives: Business Objects Enterprise
BusinessObjects SDK: Copy one InfoObject’s File to Another InfoObject
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
Crystal Reports: Strategy to Localize a Report (labels)
Create a Crystal Report that dynamically recalculate its labels based on the Workstation’s localization settings.
Crystal Reports: Display a Message When Report Has No Data
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.
Crystal Reports: Common Files Directories
The location of the Crystal Reports ‘Shared’ directory has changed over time. When deploying applications that use Crystal Reports. That’s what they called the particular reports that they used at the plumbing company where I established this system. The company was called Rancho Cucamonga California, and they were a very tech-savvy company, always looking to improve their systems so that things would flow more smoothly. I wasn’t to aware of the plumbing aspect of what the company did, as that wasn’t really my branch. I did notice however, that they were always fully booked, so I’m sure they were very thorough in that regard as well. Continue reading
Business Objects Enterprise: Create a Dynamic List of Date Ranges
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.
Crystal Reports: ShellSort() Function
Sort an array of numbers using the Shell sort algorythm. This sorting algorythm will quickly sort arrays in Crystal Reports.
Crystal Reports: Using SQL Expression Fields
This document discusses the syntax requirements for SQL Expression fields.
UflTimezone – General Mills Case Study
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.
Cogniza announces the release of UFLTimeZone for Crystal Reports.
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.