Crystal Report Count formula

Posted on 2006-04-19
Last Modified: 2012-06-21
I have a sql table the table fields are Country, Number1, Number2, Number3

And I have a crystal Report, column like this

Country            Number1      Number2      Number3      Grade1      Grade2
Bangladhes      1      0      0      A
Nepali            0      1      0            B
India            0      1      0      A      
Pakistan            0      0      1      A
Nepal            1      0      1            B


Now I want automatically fix the grade in my report column as like above if Nepal is available that is B and all other Country is A, let me know how can I

Question by:MohamedAiz
    LVL 5

    Expert Comment

    can you re-phrase your question a little, I'm not sure I follow exactly what you are trying to achieve?

    What dictates the Grade?

    Author Comment

    grades are the formula fields their is two formula column , if A country is nepal that should formula result come to B and all other Country should come to A
    LVL 5

    Accepted Solution

    I'm still not sure I follow but your formula could be something like this if you are trying to populate a formula field on your crystal report where the country = Nepal

    if {country} = 'Nepal' then


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
    This is an explanation of a simple data model to help parse a JSON feed
    An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
    Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now