Dear all,

I have three (or multiple) entries from a database that I would like to include as rows in a cross-tab. Let's call them:
{ROW.A}
{ROW.B}
{ROW.C}

I have one entry as a column that I would like to include:
{COLUMN.A}

The entries in {ROW.A}, {ROW.B} and {ROW.C} consist of either a "Y" or a "N" field. I would like to include just the "Y" field, so have created three formulas to do so:
@SELECT_ROW_A_Y =
{ROW.A} = "Y"

@SELECT_ROW_B_Y =
{ROW.B} = "Y"

@SELECT_ROW_B_Y =
{ROW.B} = "Y"

I am then calling these three formulas in the cross-tab. For some reason Crystal doesn't like this and prints out surplus jargon; many Ys and Ns - more than occur in the first place!

To me, this seems like the correct way to do this, but it doesn't work. Is there a simple answer to this question? Or any other (simple!) ways to do this?

Many thanks for your help,

Andy