Contact US

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

Understanding formulas

Understanding formulas

Understanding formulas

I am a novice with Crystal reports and I am having a difficult time with the formulas.  Is there a good tutorial on the web anyplace that helps to make sense of something that I find very confusing?

RE: Understanding formulas

I don't know of anything good that covers formulas as a general topic.  The Crystal help is pretty good on individual functions.  
They work pretty much like Excel, except that in Crystal you are working with columns and generating columns instead of individual cells.

Give an example of a formula that you are struggling with and we can help.

Ken Hamady
On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

RE: Understanding formulas

Thank you for anserwing my question.  We thought we would start out with a simple Birthday list for staff in our office.  The SQL/ODBC table I am using is {employees}.  I am able to get the info I need, however I get employees that have been terminated as well.

I have done an if ({Employees.TerminationDate})< CurrentDate
  then ({Employees.SupportRecordStatus}) ="I"

 This shows us the ex staff members, I have done a grouping  and stuck them on the bottom of the report.  What I would really like to do is have them not show at all.
I am just not sure how to word the formula.
Thank you for your time.

RE: Understanding formulas

Hi, I managed to have the info not show up by using the select expert and choosing employees.supportrecordstatus "is not like" + "I"

Thank you for your help.

RE: Understanding formulas

You can now look at the formula that CR created and see the correct syntax.

Ken Hamady
On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

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! Already a Member? Login

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