Crystal Reports for VB - Referencing Current Field in a Formula

Posted on 2007-08-01
Last Modified: 2013-11-26
I have a large number of fields in a Crystal Report (version packaged w/ visual studio 2005) and I would like all of those fields to have the exact same function for suppressing the information.  Do I have to go into each individual field and write the formula explicitly naming the current field, or is there a way to select all of them and find the text in the current control w/o explicitly naming that field?  

Right now, the only way I know how to suppress a field based on its text is by using the field name in the suppress function:
{rptRestChart.Day1Code1} = "0/00"

I'd like to be able to have something more like:
me.Text = "0.00"
that will work for all my fields w/o having to edit each individually.

Question by:trcannon
    LVL 28

    Accepted Solution

    I know there is a function in newer versions of CR called "currentfieldvalue", which is a self reference.
    I have used it in native Crystal Reports in the Suppression formula like this:

    currentfieldvalue = "0.00"

    Author Comment

    Thanks so much!!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Welcome my friends to the second instalment and follow-up to our Minify and Concatenate Your Scripts and Stylesheets (…
    In my previous article ( we saw the basics of serialization and how types/objects can be serialized to Binary format. In this blog we wi…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    758 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

    9 Experts available now in Live!

    Get 1:1 Help Now