So it was the Friday before the Memorial Day weekend, and before leaving for the day I decided to follow my own advice and check my backup solution to ensure it was functioning properly. I’m glad that I did, because it had been silently failing for over a week. Now that it has been fixed I want any early warning system. (more…)
Month: May 2016
-
Code Golf: Count formula
Time to play a little code golf, where we try to find the shortest possible source code to accomplish a given task. I’m going to be taking on a formula in Crystal Reports that changes a running total
(more…){#Count}into a text string to be used as a line label. The string should be formatted with an numeral followed by a period. -
![Select Top 3 * From [Uses for Select]: Part 3](https://petrovay-com.s3.us-east-2.amazonaws.com/three-flickr-16206784972.jpg)
Select Top 3 * From [Uses for Select]: Part 3
So far, we’ve examined how to use the
SELECTstatement in SQL to create SQL Views for use in Crystal Reports, and as List Views in TMS. Now we are going to use theSELECTstatement to create an alert in TMS. (more…)