Skip to Content

Suppression logic formula help

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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.

    Add comment
    10|10000 characters needed characters exceeded