Can you write logic into AI for a report? An example formula in crystal would be below. With ?PARAMETER_NAME being a selected parameter the user selects.
Code:
If ({TABLENAME.FIELDNAME1}) = ({?PARAMETER_NAME}) Then {TABLENAME.FIELDNAME1}   Else
If ({TABLENAME.FIELDNAME2}) = ({?PARAMETER_NAME}) Then {TABLENAME.FIELDNAME2}   Else 
If ({TABLENAME.FIELDNAME3}) = ({?PARAMETER_NAME}) Then {TABLENAME.FIELDNAME3}

Basically, I have a value that has the potential to be in 1 of 7 fields. I have only shown 3 above, but one could keep going to 7. I want to show one column that represents that value only if and when it is found. If a record does not have the desired value then don't show that record. If it does have the desired value show that record and show that value in this column.

Thanks all,

Kyle