Determines if a string value is contained in an array of strings.
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.
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
A SQL Server, scalar-value function that returns the greater of two dates.
A SQL Server, scalar-value function that returns the lesser of two dates.
Use a VB Script file to import .DTS files into the local Sql Server database.
This script will export all Outlook Contacts as vCards. Continue reading
Convert a Windows AD account name to the individual’s actual name, using ADSI.
This user-defined function creates a table of date ranges. Continue reading
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.