on 06-22-2017 10:44 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.