In a report I'd like several fields not to be printed in a line if one of them has a repeated value. For example, if a product name is repeated I'd like not to print the units per case either.

Originally I solved this by appending the product name to the units per case and making the width of the field narrow enough so the appended name was not printed. Now I am offering the user the option of exporting the report to excel and naturally the appended product name goes along. The user is not asked the report destination until after all data is prepared, and that is done in a process that I prefer not to touch, so it is not really feasable to change the value in the cursor.

Sounds like a job for dynamic formating, except I don't know how to accomplish it.

TIA,

Alex