Most of us can agree that Firefox is pretty much the hottest browser around. It has excellent standards compliance (bested only by Opera) and the richest collection of extensions around. In addition, it provides a level of configurability that we normally only get to dream about; through the page "about:config" you can tweak the behavior of practically everything in the browser. Sometimes programs appear that perform the same sort of task, for example fasterfox whose only purpose is to tweak some of these settings for you.
How-To: Tutorials and Walkthroughs
You might actually be looking for this other page from which I get occasional page referrals. It has ready-made binaries.
Aristocrat OASIS' stored procedures require some input in order to function properly. The most important elements to understand are the date specification, the iLockKey value, and the iApplication_ID.
Rules for Player Reports
(Adapted from Beginning Crystal Reports v.6.0 Guidebook, Aristocrat Technologies, 2002.)
Due to the abject uselessness of Aristocrat's website, there is no way to just look up the information in the tutorial documentation (or anything else.) Thus, I have created this document to list formulas useful in crystal reports for processing OASIS data.
Even if this information were copied verbatim from the tutorial document and placed on the web, it would still contain errors. (See the first example in the Advanced Crystal Reports guidebook from 10/17/02 on page 12.)
Given that Crystal has no array-sorting functions, there is often a need to write one. An insertion sort is the most efficient of the particularly simple and short sort algorithms, working well with short sets, whether they are already substantially sorted or not.
Crystal Reports 9 provides no way to sort an array. If you want to calculate the median value for an array, it must be sorted. On the other hand, it does provide comparisons that work properly based on data type, so that for example ( "Alice" < "Bethany" ) will evaluate true. The following examples are designed to sort numerical arrays but they can as easily sort strings or any other data types in Crystal.
Among the many pieces of obvious functionality missing from Crystal is a median function that will operate on an array. The median is not horribly difficult to calculate, but in order to do so you need a sorted list of values. Another obvious thing Crystal is missing is an array sort function. The median of a list is its middle value by position such that of the set (1, 3, 3, 4, 6) the median is 3 while the average is 3.4. While it does not look very useful with a short set of only five elements, it is often useful when you have one or two hundred of them. It is often much more useful than an average when you have a lot of redundancy in your set.
Converting a bunch of Seconds to something Useful
A lot of databases store time elapsed as a number of seconds. This is sufficiently granular for most purposes and it is programatically a lot easier than storing day, hour, minute, second and so on values.
When it comes time to introduce a human to that data, the big number of seconds isn't going to mean diddly. Enter the following formula:
Crystal Reports 9 [CR9] allows you to create a median summary field, but not to get the median for an array. Sure, you can get an average, or a mean, but not a median. If you want the median of a list of values, they must first be in order, which is outside the scope of this document (but there are other documents on sorting arrays.)