BusinessObjects SDK: Change a Universe’s Data Connection

No Comments »

Change a Universe’s Data Connection without using the Universe COM SDK. Read the rest of this entry


BusinessObjects SDK: Copy one InfoObject’s File to Another InfoObject

No Comments »

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. Read the rest of this entry


SQL Server: Date Arithmetic

No Comments »

Useful, dynamically-generated dates for SQL Server. Read the rest of this entry


Crystal Reports: FractionToDecimal() Function

No Comments »

Converts a fractional value in the format of Numerator/Denominator or Whole + Numerator/Denominator to a decimal value.
Read the rest of this entry


Crystal Reports: Strategy to Localize a Report (labels)

No Comments »

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

Read the rest of this entry


Adobe Acrobat – Printing Legal Landscape Documents

No Comments »

By default, Adobe Acrobat Reader will scale a landscape-oriented, legal-sized document to letter-sized paper.  Fortunately, this scaling can be easily removed.

Read the rest of this entry


Crystal Reports: Array_PushEx() Function

2 Comments »

Add a unique string value to an array of string values. Uses the delimiter to convert the value into an array. Read the rest of this entry


Crystal Reports: Array_Push() Function

No Comments »

Add a string value to an array of strings, only if string value hasn’t already been added to the array. Read the rest of this entry


Crystal Reports: Array_Contains() Function

No Comments »

Determines if a string value is contained in an array of strings.
Read the rest of this entry


Crystal Reports: Display a Message When Report Has No Data

No Comments »

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.

Read the rest of this entry