Change a Universe’s Data Connection without using the Universe COM SDK. Continue reading
Category Archives: Programming
BusinessObjects SDK: Copy one InfoObject’s File to Another InfoObject
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. Continue reading
SQL Server: Date Arithmetic
Useful, dynamically-generated dates for SQL Server.
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
SQL Server: Greater() Function
A SQL Server, scalar-value function that returns the greater of two dates.
SQL Server: Lesser() Function
A SQL Server, scalar-value function that returns the lesser of two dates.
SQL Server: Import DTS Packages using a Script
Use a VB Script file to import .DTS files into the local Sql Server database.