Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Business Objects: Crystal Reports 4 Other topics FAQ

Common Formulas

Data Types in Crystal Reports by kenhamady
Posted: 14 May 01 (Edited 5 Jun 04)

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

Back to Business Objects: Crystal Reports 4 Other topics FAQ Index
Back to Business Objects: Crystal Reports 4 Other topics Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close