Crystal Constant for hidden ?

[CarpalT]

Crystal 8.5
I have been looking for a list of the constants that can be used in formulas. I can find partial lists in CR "help", but nothing at all on the BO web site. What I am specifically trying to do today is hide a field depending on the value of another field, whether it is hidden or not. From time to time I accidently run across a few of their constants, but never the whole list. This would make a great FAQ if someone knows them all.
But for today, is there a constant for hidden?
Thanks!

 

[synapsevampire]

Right click the field and select format field, then click the X2 next to Suppress for the field and use something like:

{table.otherfieldvalue} in [1,2,3]

Replacing {table.otherfieldvalue} with the other field, and the in [] with whatever conditions you have.

-k

 

[CarpalT]

Good afternoon, -k
I can't find a way take the simple straightforward approach on this.

The fields are in GF1. I want to suppress it if the values of two fields in GF2 immediately above it are 0. And I want to embed it in a text box with some other text so that there are no spaces. I thought I'd have to create a formula that had the field in it, with logic that set the attributes to suppressed when the condition was met, then put that in the text box.

 

[lbass]

Since summaries in the last instance of GF2 will be read in GF1, you could create a formula like:

(
if sum({table.fieldA},{table.group2field})+
sum({table.fieldB},{table.group2field}) = 0 then "" else
<field you want to display>
)

You can drop this into the text box in GF1.

-LB