On Location TrainingPublic ClassesIndividual TrainingIntroductory Course OutlineAdvanced Course OutlineFormula ExamplesNewsletter Back IssuesMy BlogResource LibraryConsulting ServicesSupport ServicesContact InformationLinks to third party productsBack to main pageMy Credentials

ReCrystalize

Ken Hamady's Crystal Reports Formulas

 To understand the techniques used in these formulas you may want to get:

         
The Expert's Guide to Crystal Reports Formulas
           and
           Expert Techniques for Crystal Reports I, II & III

1. The number of "business days" between any two dates

2. Converting a numeric date to a true date

3. Converting a character date to a true date

4. Use a parameter prompt to select the sort/group order, using fields of mixed data types

5. Adding a month or months to a date

6. Calculating an accurate age Integer from a date of birth

7. Printing parameter selections for multiple or range values

8. Making multiple variable assignments in one formula

9. Converting total seconds to a formatted "elapsed time" string

10. Conditional total using an If-Then-Else formula

11. Conditional total using a running total

12. Manual cross-tabs (cross-tabs that allow formulas)

13. The number of business hours between two datetime values

14. Distinct count of an If-Then-Else formula 

15. Convert decimal numbers to text, showing only the non-zero decimal places

16. Append a list of detail strings into one line

17. Adding a number of business days to a date

18. How to print "continued on next page"

19. Finding the last Friday of the month

20. Removing the path from the "File Path and Name" field

21. Find Monday of a specific week (using ISO standard week no.)

22. Rounding to the nearest nickel, or other odd increment

23. Finding the first Friday of the month

24. Finding the number of Fridays in a date range

25. How to find Good Friday (or Easter) for any year

26. How to generate a list of common holidays for any year

27. Today's date in contract format

28. Grouping by a non-calendar week

29. Converting a decimal to fraction

30. Calculating periods in 5-4-4

31. Calculating fiscal YTD

32. Calculating fiscal and calendar quarters


Copyright 2000-2010 by Ken Hamady - All rights reserved.  Republishing this material requires written permission