CAT | Crystal Reports
15
Crystal Reports: Dynamic Images
2 Comments · Posted by Craig Buchanan in Crystal Reports, Technique
Use a conditional formula to dynamically change the location of a report’s image. (more…)
8
Crystal Reports: FractionToDecimal() Function
No comments · Posted by Craig Buchanan in Crystal Reports, Functions, Programming
Converts a fractional value in the format of Numerator/Denominator or Whole + Numerator/Denominator to a decimal value.
(more…)
9
Crystal Reports: Strategy to Localize a Report (labels)
1 Comment · Posted by Craig Buchanan in Business Objects Enterprise, Crystal Reports, Programming, Technique
Create a Crystal Report that dynamically recalculate its labels based on the Workstation’s localization settings.
Business Objects Enterprise · Crystal Reports · Localization
1
Adobe Acrobat – Printing Legal Landscape Documents
No comments · Posted by Craig Buchanan in Adobe Acrobat, Crystal Reports
By default, Adobe Acrobat Reader will scale a landscape-oriented, legal-sized document to letter-sized paper. Fortunately, this scaling can be easily removed.
9
Crystal Reports: Array_PushEx() Function
2 Comments · Posted by Craig Buchanan in Crystal Reports, Functions, Programming
Add a unique string value to an array of string values. Uses the delimiter to convert the value into an array. (more…)
9
Crystal Reports: Array_Push() Function
No comments · Posted by Craig Buchanan in Crystal Reports, Functions, Programming
Add a string value to an array of strings, only if string value hasn’t already been added to the array. (more…)
9
Crystal Reports: Array_Contains() Function
No comments · Posted by Craig Buchanan in Crystal Reports, Functions
Determines if a string value is contained in an array of strings.
(more…)
28
Crystal Reports: Display a Message When Report Has No Data
No comments · Posted by Craig Buchanan in Business Objects Enterprise, Crystal Reports, Technique
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.
15
Crystal Reports: Common Files Directories
No comments · Posted by Craig Buchanan in Business Objects Enterprise, Crystal Reports
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. (more…)
24
Business Objects Enterprise: Create a Dynamic List of Date Ranges
4 Comments · Posted by Craig Buchanan in Business Objects Enterprise, Crystal Reports, SQL Server, Technique
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.
Business Objects · Business View · Crystal Reports · Date/Time · Parameters · SQL Server

