Cross Tab Summary 1

[rdeleon]

I have what seems to be a simple problem, but I can't put my finger on how to do it. I've got a cross tab report that is working fine, except, instead of a count summary, I just want to put an "X" if the count is > 0.

So that I get the following:

col1 col2 col3
row1 X
row2 X X
row3 X

Am I overlooking the obvious?

Rene'

 

[lbass]

I think the following would work:

Create a formula {@X}:

if isnull({table.field} then "" else "X"

Then use {@X} as your summary field and choose "Maximum" (NOT count) as your summary field.

-LB