If I understand you correctly, you actually have 4 fields - one that contains the whole record ID and one each for the three parts of the record ID.  Correct?

 

Assuming that Sort3 is null when there are only two components, try this:

 

1.  Create a formula (I'll call it "SelectIt") that looks something like this:

IsNull({table.Sort3})

 

2.  In the Select Expert, edit the selection formula by clicking on the formula button and adding the following to whatever criteria is already there:

and {@SelectIt}

 

This will return to your report only the records where there is no Sort3 value.

 

-Dell

 

This is a different kind of record suppression, & I hope I can explain it adequately.

 

In the report that I'm writing, the primary table I'm using is called Parties.  So each record is about one person.  There is information about this person in other tables.  So I am pulling in fields from the Catalog table, which is about objects, to see how the person is related to the object. 

 

There are fields in the Catalog table that tells how the person is historically related to the object.  There may be more than one person that is historically related to the object in the Catalog table record, people other than the person in my report from the Parties table. 

 

So, say, a person in one of my records in my report is Joe Smith.  But the people in the repeating Historically Related field are Joe Smith, Mary Jones, & Susan Dey.  I only want to see Joe Smith as the Historically Related person in my report.  Thus, I want to suppress the entries in the Catalog table for the Historically Related People of Mary Jones & Susan Dey. 

 

Does anyone know how I could create a formula to do this?