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
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.
Outlook: Export Contacts to vCards
This script will export all Outlook Contacts as vCards. Continue reading
Visual Basic: Convert a Windows AD account name to a 'real' name.
Convert a Windows AD account name to the individual’s actual name, using ADSI.
Sql Server: DateRanges() Function
This user-defined function creates a table of date ranges. Continue reading
Sql Server: GetNow View
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.