HI All,
I want to suppress group header base on the following criteria. There are 2 tables: Main and Company
I want to suppress if Main table "Amount" = 0 and Main table Customer name <> Company table Customer name. In other words, suppress Main table Amount column = 0 AND dont suppress Customer Name exist in both tables. Hope this make sense. Many Thanks.
Frank
Jun 23, 2017 at 03:49 PM
The question is not clear. You already mentioned the suppression formula:
MainTable.Amount = 0 and MainTable.Customer name <> CompanyTable.Customer name.
Are you saying the formula does not work? Try OR instead of AND:
MainTable.Amount = 0 OR MainTable.Customer name <> CompanyTable.Customer name.