Originally posted by kurt
That helps, but I need to also specify which record to use. Each record will match like 10 categories in the view. I need to select the category which matches "xxx".
if
(
If table.category matches "xxx"
then select table.field
)
then chr(252)
else chr(168)
What if you Group By the record, and instead of displaying the Category you use a Formula where some sort of calculation occurs.
Formula 1: if Category = "xxx" set someGlobalVariable = true
Formula 2 (to replace Category in the report display): if someGlobalVarialbe = true then table.field + chr(252) else chr(168)
The part that eludes me at the moment is how to set the variable back to false for each iteration, or else somehow have the variable unique to the specific record grouping. This may be a pipe dream but I've done similar things before.