• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1270
  • Last Modified:

Crystal Reports for VB - Referencing Current Field in a Formula

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.

1 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"
trcannonAuthor Commented:
Thanks so much!!

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now