Crystal Reports

Question

I am a newbie to Crystal Reports. There is a Parameter which has 2 values Yes and NULL in the mapped database column. I am trying to create a cross table with count, like -

Name    Yes   NULL
ABC      5     2
XYZ      3     7

How can I display 'No' in place of Null like --- Name Yes No

Answer 1

Substitute No for Null on the db side if you can.

Answer 2

As Beth suggests, this sort of thing is often easier on the DB (ie. query) side.

If you really want to do it in Crystal, create a new appropriately-named formula, with an expression similar to this:

If IsNull ({TABLE.FIELD}) Then "No" Else {TABLE.FIELD}

and change your crosstab to group on the formula, instead of the TABLE.FIELD value.