Smart questions
Smart answers
Smart people
Join Tek-Tips Forums
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • 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!

Join Tek-Tips
*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.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

MsRae (IS/IT--Management) (OP)
21 Jan 05 11:01
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?

Thanks.

Rae

kskid (TechnicalUser)
21 Jan 05 11:08
I use Crystal 8.5 and they are listed in the Function Tree within the Formula Editor

-LW
vidru (Programmer)
21 Jan 05 11:12
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.

-dave
Madawc (Programmer)
21 Jan 05 11:21
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)

kskid (TechnicalUser)
21 Jan 05 11:43
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.

Cheers,

-LW


MsRae (IS/IT--Management) (OP)
21 Jan 05 14:54
Thank you all for the help. I am using Crystal Reports 9 Professional.

Rae

Helpful Member!  Jacque (TechnicalUser)
25 Jan 05 16:04
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.
Jacque
Madawc (Programmer)
27 Jan 05 5:35
Jacque , thanks for a useful tip.  You should post it as a 'helpful hint' in its own right.

Madawc Williams (East Anglia, UK)

synapsevampire (Programmer)
27 Jan 05 16:03
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:

http://support.businessobjects.com/communityCS/FilesAndUpdates/cr85_help_file.zip.asp

Integration:

http://support.businessobjects.com/library/kbase/articles/c2003667.asp

CR 9 Custom Functions:

http://support.businessobjects.com/library/kbase/articles/c2011369.asp

http://support.businessobjects.com/library/kbase/articles/c2013360.asp

-k
MsRae (IS/IT--Management) (OP)
28 Jan 05 22:31
Thanks to everyone for your help. This has guided me in the right direction.

Rae

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