Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Andrzejek on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data Types in Crystal Reports

Common Formulas

Data Types in Crystal Reports

by  kenhamady  Posted    (Edited  )
When asking a question in the forum that relates to formulas it is essential that you know the data types of all database fields involved. The basic 4 types are Number, Character, Date and Boolean. Each of these might have several subtypes like Currency, VarChar, DateTime, etc.

The essential thing to uncover is the data type as seen by Crystal Reports. Keep in mind that this may not be the same as the data type specified in the database. To know what Crystal is seeing, place the field onto the canvas (design screen), right click on the field, and select "Browse Field Data". This will show you sample values, and will also show you the data type as seen by Crystal Reports.

DataType is not the same as Format. This is especially true for dates, which can be formatted in any number of ways. This, however, has no effect on the data type of the underlying field.

So, when you ask a question about a formula, please include the data type of the fields involved in your post. If it is a character field include some sample values.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
http://www.kenhamady.com/
tek2(AT)kenhamady.com
Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top