very confusing suppress funtionality 1

[yehong]

I need help in supressing a text (X) conditionally under three columns.
Exp:
Talble1.field1, table1.field2
Test values
field1=Fname+Lname1
field2=Low, Med, High
Now when

This is how the report should look for say three individuals.

Low Med High
X
X
X
I just need to show X under each column where value exists for each individual.
Hope this helps in understanding this question.
Cr version 8.5.

 

[synapsevampire]

It's best to show example data and expected output. Your post appears incomplete also, as it says "Now when" without anything afterwards.

A simple means would be to create 3 formulas such as:

If {table.field2} = "Low" then
"X"
else
""

If {table.field2} = "Med" then
"X"
else
""

If {table.field2} = "High" then
"X"
else
""

Place each in the details.

If you then need counts, use Running Totals to count {table.field2} with the same criteria in the evaluate use a formula, except use:

{table.field2} = "Low"

etc.

-k