This is really strictly related to Crystal Reports and has nothing to do with VFP.
I have a Crystal report that is reporting on SQL Server data linked to a third party Property Management application.
The data is queried from the server via a custom script that is read by this 3rd party application.
The first two fields are called Unit No. and Tenant Name. My script is set to insert the string "VACANT" if the unit has no matching
tenant. For occupied units the report may print multiple lines of data for any given tenant. For those tenants, I would like to
suppress their name from printing multiple times. But if I select the "Suppress If Duplicated" option on the field formatter, instances
of multiple "VACANTS" in a row are also suppressed, even if they are for different units. Let me see if I can draw it out:

THIS IS WHAT I WANT:

Unit No.         Tenant Name         Rent       Term
101             Joe Blow            $500        Year 1
102             Tommy Smith         $500        Year 1
                                    $550        Year 2 
                                    $600        Year 3
103              VACANT              N/A        N/A
104              VACANT              N/A        N/A
105              VACANT              N/A        N/A


BUT THIS IS WHAT HAPPENS WITH SUPPRESS DUPLICATES ON:

Unit No.         Tenant Name         Rent       Term
101             Joe Blow            $500        Year 1
102             Tommy Smith         $500        Year 1
                                    $550        Year 2 
                                    $600        Year 3
103              VACANT              N/A        N/A
104                                  N/A        N/A
105                                  N/A        N/A

How do I suppress duplicate tenant names without suppressing the duplicate "VACANTS"?
I figure I'll have to do something with a formula. But I'm not sure what I should do.

Thank you very much.