This user-defined function creates a table of date ranges. Continue reading
Sql Server: DateRanges() Function
Leave a reply
Monthly Archives: May 2006
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.
Crystal Reports: CDateRange() Function
Convert a string value into its equivalent Date Range.
Business Objects Enterprise: Create a Dynamic List of Date Ranges
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.
Crystal Reports: getLocalizedString() Function
getLocalizedString is a Crystal Reports Custom Function to used convert a constant to a localized string.
Crystal Reports: Report Processing Model
Crystal Reports uses a three-pass reporting method to generate reports. The sections below describe what happens during each step of this process. To see a visual representation, refer to the flow-chart at the end of this section
Continue reading
Crystal Reports: FirstMonday() Function
Finds the the first Monday in the current month.
Crystal Reports: Pad() Function
Adds the specific character to the left side of a value when the value is less than a comparison. Useful when converting a single-digit month or day to a string.
Visual Basic: Generate a List of Installed COM Compontents
It is often useful to see a list of installed COM components on a given machine. The Component Explorer uses the registry and Microsoft’s Typelib component to generate this list.
Visual Basic: NNTP Message Threader
This application demonstrates how to use the Microsoft Xml component thread NNTP messages by id or subject. In addition, the application uses a plugin architecture to wrap the Nntp components from IpWorks! and ServerObjects.
Continue reading