November 2010 Entries

Age this month calculation in Crystal Reports
I keep having lots of fun developing enterprise reports with the excellent Crystal Reports. Today I needed to calculate the age of a person for this month. The typical use of this formula would be something like “determine if an employee is turning 65 years old this month). I was able to come with the following Crystal Formula Syntax: // Age this month calculation WhileReadingRecords; dateTimeVar _1stOftheMonth := CurrentDate; dateTimeVar LastOftheMonth := CurrentDate; // Get the run date and make ......

Posted On Thursday, November 25, 2010 10:03 AM | Comments (1)

Free SQL IDEs Review – SQL Everywhere vs. Toad for SQL Server
Recently I have been given a short term assignment to develop a number of reports in Crystal Reports. Upon arriving to the client location I quickly found out that the only tool I will be using to create the reports is basically the Crystal Reports itself. My initial look at the database quickly revealed that the database structure is far from perfect and that it has some confusing table relationships, another hurdle was in the fact that several columns in various tables were user customizable for ......

Posted On Sunday, November 7, 2010 1:15 AM | Comments (2)

Crystal Report Would Support Syntax >= but not > = in a Formula!
Getting “A number, currency amount, boolean, date, time, date-time, or string is expected here.” in Crystal Reports formula? Do you know, Crystal Reports (I am on version 2008) would not support > = (yes, with a space), but >= ? Example: this is an invalid statement: if {Command.MyAge} >= 65 then “Start saving money!” else “Keep spending :-)”; Why it is so difficult to not have both cases working? Hah, spent extra 15 minutes figuring out why I get this error ......

Posted On Monday, November 1, 2010 4:12 PM | Comments (0)