Thursday, April 26, 2012

Programming Test


Given a list, array, of integers, find the index of the two consecutive numbers which have the largest sum.
For example, if the array is 1, 2, 3, 4, 5, the answer is 4, as 4+5 = 9.

Wednesday, April 11, 2012

How to format a phone number/Fax number in crystal reports formula

Use Picture({field.PhoneNum},"(xxx) xxx-xxxx").

How to check if a string field contains a character in crystal reports formula

You can use Instr({text.field},'-') > 0 - indicates there is a character in the string field..
if  Instr({text.field},'-') = 0 - indicates there are no such characters in the string field.