Use a conditional formula to dynamically change the location of a report’s image. Continue reading
Tag Archives: Crystal Reports
Crystal Reports: FractionToDecimal() Function
Converts a fractional value in the format of Numerator/Denominator or Whole + Numerator/Denominator to a decimal value.
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: Array_PushEx() Function
Add a unique string value to an array of string values. Uses the delimiter to convert the value into an array. Continue reading
Crystal Reports: Array_Push() Function
Add a string value to an array of strings, only if string value hasn’t already been added to the array.
Continue reading
Crystal Reports: Array_Contains() Function
Determines if a string value is contained in an array of strings.
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
Crystal Reports: CDateRange() Function
Convert a string value into its equivalent Date Range.
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.