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.