CAT | Technique
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…)
5
SQL Server: Date Arithmetic
No comments · Posted by Craig Buchanan in Programming, SQL, SQL Server, Technique
Useful, dynamically-generated dates for SQL Server. (more…)
Date · Programming · SQL · SQL Server · T-SQL
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
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.
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
