Archive for May 2006
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.
25
Crystal Reports: CDateRange() Function
No comments · Posted by Craig Buchanan in Functions, Programming
Convert a string value into its equivalent Date Range.
24
Business Objects Enterprise: Create a Dynamic List of Date Ranges
4 Comments · Posted by Craig Buchanan in Business Objects Enterprise, Crystal Reports, SQL Server, Technique
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.
Business Objects · Business View · Crystal Reports · Date/Time · Parameters · SQL Server
14
Crystal Reports: getLocalizedString() Function
2 Comments · Posted by Craig Buchanan in Functions, Programming
getLocalizedString is a Crystal Reports Custom Function to used convert a constant to a localized string.
14
Crystal Reports: Report Processing Model
No comments · Posted by Craig Buchanan in Crystal Reports
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
(more…)
8
Crystal Reports: FirstMonday() Function
No comments · Posted by Craig Buchanan in Crystal Reports, Functions, Programming
Finds the the first Monday in the current month.
8
Crystal Reports: Pad() Function
1 Comment · Posted by Craig Buchanan in Crystal Reports, Functions, Programming
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.
6
Visual Basic: Generate a List of Installed COM Compontents
No comments · Posted by Craig Buchanan in Programming, Visual Basic
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.
No tags
5
Visual Basic: NNTP Message Threader
No comments · Posted by Craig Buchanan in Programming, Visual Basic
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.
(more…)
COM · NNTP · Programming · Visual Basic
