Field Suppression based on 'is not in' Criteria

See more:

CrystalReports

Hi there...I'm hoping you can help me.

I am using Crystal Reports 2011. In my report, I have grouping based on a certain field. I want the details for that group to display certain columns based upon the data in the field that the group is based on.

For example, if the Grouping field is 'CON' I want the columns as follows:

Location Material Notes

If it's 'FRAM' display:
Item Description

If it's 'HDSFC' display:
Description Type Splash Application Edge Group

And so on...

There are over 20 options that can all be on the same report at once (possibly 20+ groups appearing on one report).

The groups I'm OK with, but how on earth do I get it to display columns conditionally? Any help would be GREATLY appreciated.

UPDATE: I figured out how to get certain columns to display by doing mulitple groups/sections. However, they are all going to use the same footer, and the fields that show up need to be suppressed based on a certain criteria (the value of a certain field).

I tried doing 'is not in' and all of the values that I want to display with that field, but it's giving me an error that "the remaining text does not appear to be part of the formula".

{FieldName} is not in ('CON', 'SID')