Null Values

[mmt4331]

I have a few null values in a database field called {Asgnment.Resolution}. On my report, I have a few other database fields going across the report. How do I suppress the other fields if my {Asgnment.Resolution} field has a null value? Thx.

Mark

 

[dgillz]

You can suppress these fields with a right click on the field, select format field, hit the x-2 button to the right of the "suppress" checkbox on the comman tab and enter a formula - IsNull({YourField}).

However this will leave blank spaces on the report, and any suppressed records wuill still evaluate in any sub or grand totals you have.

You probably want to exclude these records from your report altogether with a record selection formula. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[dgillz]

You can suppress these fields with a right click on the field, select format field, hit the x-2 button to the right of the "suppress" checkbox on the comman tab and enter a formula - IsNull({YourField}).

However this will leave blank spaces on the report, and any suppressed records will still evaluate in any sub or grand totals you have.

You probably want to exclude these records from your report altogether with a record selection formula. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[synapsevampire]

Right click the section you wish to suppress if one field is null, select format section->X-2 next to suppress and place something like:

isnull({Asgnment.Resolution})

Leaves no spaces, it just eliminates that section if the field is null.

As dgillz mentions, you're porbably better served to eliminate the data from the return set by using Report->Edit Record Selection->Record and placing something like:

isnull({Asgnment.Resolution})

The rows will be filtered out of the report.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[mmt4331]

Thx synapsevampire. I went into the record selection and put the following formula in:

{Asgnmnt.AssignedBy} = &quot;mmt4332&quot; and {Asgnmnt.Resolution} <> &quot;&quot;

It worked. Thx again!

Mark

 

[synapsevampire]

No worries, though that probably doesn't eliminate nulls, a null is not the same as &quot;&quot;, but perhaps your table doesn't contain null.

I'd place both

(
{Asgnmnt.Resolution} <> &quot;&quot;
or
isnull({Asgnmnt.Resolution})
)

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[synapsevampire]

No worries, though that probably doesn't eliminate nulls, a null is not the same as &quot;&quot;, but perhaps your table doesn't contain null.

I'd place both

(
{Asgnmnt.Resolution} <> &quot;&quot;
or
not(isnull({Asgnmnt.Resolution}))
)

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[mmt4331]

Thx Vampire: I put the isnull part of the formula in the Select Expert and everything works fine. Thx for your help.

Mark