Enhancing the Basic Report › Formatting Numeric Data › What You Can Do

What You Can Do

You can format numeric data automatically by using format codes supplied by CA Culprit or by using your own patterns.

How to Do It

Use a format code on the type 5 line. Useful format codes for printed output are:

• FN—Prints leading zeros and omits commas in numbers such as those used for employee identification.
• FS—Inserts dashes in social security numbers.
• FD—Inserts slashes in dates.
• F$—Inserts dollar signs in monetary information.
• FM—Formats fields according to a specified pattern. The numeric field is symbolically represented as follows:
  • 9s and Zs represent digits. The Z suppresses leading zeroes.
  • Periods (.) represent decimal points.
  • Special characters (for example, slashes or asterisks) are preceded by a printable digit.