getLocalizedString is a Crystal Reports Custom Function to used convert a constant to a localized string.

(more…)

Crystal Reports · Functions · Localization · Programming

Crystal Reports uses a three-pass reporting method to generate reports. The sections below describe what happens during each step of this process. To see a visual representation, refer to the flow-chart at the end of this section
(more…)

Crystal Reports

Finds the the first Monday in the current month.

(more…)

Crystal Reports · Date/Time · Functions · Programming

Adds the specific character to the left side of a value when the value is less than a comparison. Useful when converting a single-digit month or day to a string.

(more…)

Crystal Reports · Functions · Programming

Converts a number of seconds into a string in the format of days.hours:minutes:seconds.

(more…)

Crystal Reports · Date/Time · Functions · Programming

Often it’s useful to be able to use date ranges that are relative to the date the report was run, like ‘Month to Date’, when running a report. While Crystal Reports’ parameters do not possess this level of flexibility, it is fairly simple to approximate this capability. This approach uses two parameters and Crystal Reports’ date ranges to do so.

(more…)

Crystal Reports · Date/Time · Parameters

Most report designers are familiar with the parameter’s ‘Allow Multiple Values’ option. When enabled, this option allows a report’s user to select one or more values for a parameter at runtime. The individual running the report could select one or more countries, for example. Should the individual want to select all countries, he or she would need to add each country individually when the prompt is presented. If there are a lot of countries, this could be a time-consuming task. Fortunately, there is a better way.

(more…)

Crystal Reports · Parameters · Technique

In this sample, we will create a report that generates a form letter to each customer, with terms and conditions on the back side (represented as Cogniza’s logo). Moreover, the page numbering will only count the front of each page.

(more…)

Crystal Reports · Technique

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