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…)
30
Visual Basic: Create a Sorted Collection
No comments · Posted by Craig Buchanan in Programming, Visual Basic
Create a sorted Visual Basic 6 collection that is similar to sorting an ArrayList in Visual Basic .Net.
26
SQL Server: MaximumDate() Function
No comments · Posted by Craig Buchanan in Programming, SQL Server
A SQL Server, scalar-value function that returns the greater of two dates. (more…)
26
SQL Server: MinimumDate() Function
No comments · Posted by Craig Buchanan in Programming, SQL Server
A SQL Server, scalar-value function that returns the lessor of two dates. (more…)
16
SQL Server: Import DTS Packages using a Script
1 Comment · Posted by Craig Buchanan in Programming, SQL Server
Use a VB Script file to import .DTS files into the local Sql Server database.
9
Outlook: Export Contacts to vCards
1 Comment · Posted by Craig Buchanan in Outlook, Programming
This script will export all Outlook Contacts as vCards. (more…)
COM · Contacts · Outlook · Programming · vCard · Visual Basic
14
Visual Basic: Convert a Windows AD account name to a 'real' name.
No comments · Posted by Craig Buchanan in Programming, Visual Basic
Convert a Windows AD account name to the individual’s actual name, using ADSI.
25
Sql Server: DateRanges() Function
No comments · Posted by Craig Buchanan in Functions, Programming, SQL Server
This user-defined function creates a table of date ranges. (more…)
The Sql Server GETDATE() function not allowed in the body of user-defined functions, as it is non-deterministic. The GetNow view provides a means to generate a system date/time that can be used in Sql Server user-defined functions.
