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!
  • Students Click Here

*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


List of Functions

List of Functions

List of Functions

Is there a listing of available functions? For example, how would I know I could use onlastrecord in the formula? Where did that function come from?



RE: List of Functions

I use Crystal 8.5 and they are listed in the Function Tree within the Formula Editor


RE: List of Functions

Use the Help files.  If you've got them installed using the Compiled HTML format (.chm), on the 'Contents' tab, everything is nicely grouped (Formulas, Functions, Operators, etc.).  Everything you ever wanted to know about formulas/functions is right there, with an explanation, and usually an example of its use.


RE: List of Functions

I don't think there's anything better than the Help function, if you've got it.  Or look here and see what people are using.

I started off with the functions listed under 'Operations' and 'Functions', but soon gave up on them.  (If anyone out there can follow the logic of what's there and what isn't, I'd be interested to hear it.)

It helps to give your Crystal version, since newer versions have extra options, extraa functions and some extra problems.   I use Crystal 8.5, though we are currently upgrading to Crystal 10.

Madawc Williams (East Anglia, UK)

RE: List of Functions

I agree on the Help.  Many times the funtion tree does not provide enough information so I just click on the question mark (?) button get to the Help menu and go from there.

Under the index tab in the Help, if you enter Function (or Operator) to get a list of the functions (or operators) for both Crystal and Basic along with some good examples on it's use.

Of course, reading some of these forums provide excellent examples of real life uses of the function.



RE: List of Functions

Thank you all for the help. I am using Crystal Reports 9 Professional.


RE: List of Functions

Hi Rae,
In the formula workshop, hit ctrl + space to bring up a small scrolling window of functions, custom functions (existing in the report) and operators listed alphabetically.  Click esc to close the window.  One caveat is that it doesn't provide the formatting display of the syntax.

Once you find the name of the function you want, click on the find function (binoculars) and search for the function or operator (also field or text).  You will be taken to the function, custom function or operator.

RE: List of Functions

Jacque , thanks for a useful tip.  You should post it as a 'helpful hint' in its own right.

Madawc Williams (East Anglia, UK)

RE: List of Functions

Functions are listed in the formula editor, and your help system lists all functions, and Jacque's technique is useful.

It sounds like you're new to CR, try the following:




CR 9 Custom Functions:




RE: List of Functions

Thanks to everyone for your help. This has guided me in the right direction.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

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