Formula field for Formatting a Section

[tekniks]

Can formula fields be used for conditional formatting of a Section in CR8.5?
I want to suppress a section if the result of a formula field in the section returns no value or is empty.

I tried to use -- ISNULL(@G_LG_Mat_Id) but it throws an error saying -- "The )is missing"

Thanks for your assistance...

Tek

 

[bdreed35]

At a quick glance it looks like you are missing the curly braces around the formula name.

try this:

isnull({(@G_LG_Mat_Id})

What is in your formula anyway? Crystal pukes on nulls in formulas so I am not sure that you could even be returning a null value. Post your formula for us to see.

~Brian

 

[synapsevampire]

Try:

{@G_LG_Mat_Id)} = ""

As Brian mentioned, it's very difficult to get a formula to return a null (there is a trick, but why bother).

-k