I am trying to suppress the details section based off a formula in the group footer.

I am using the three-formula trick in my report; if the 3rd formula (placed in the group footer) equals 1, I would like the details within that group to be suppressed.

I tried entering {@3rd formula} = 1 into the section expert, suppress X+2 but doesn't evaluate correctly.

Any ideas how this can be done?

Sorry. The suppress does not work.

Hello - thank you for the response.

So, I created a formula (@first nine) that looks at the first nine numbers in field X. Field X contains a total of 11 numbers.

I grouped the report by the formula (@first nine).

Any records that may fall under the group that match the nine numbers displays, showing all 11 numbers.

Example:

111111119 Item XYZ


111111118 Item ABC
             11111111801 Item A
             11111111808 Item B
             11111111816 Item C

111111113 Item GHI


In this case, I would like to suppress 111111119 and 111111113 as there are no items that match the first nine digits.

Any suggestions on how to get this accomplished?



Edited by FECSII - 14 Jan 2019 at 4:23am

You are correct; I did not add any suppression - it looks like this:

111111119 Item XYZ
             11111111910 Item P

111111118 Item ABC
             11111111801 Item A
             11111111808 Item B
             11111111816 Item C

111111113 Item GHI
              11111111355 Item Z

Any group that has more than 1 record, I would like displayed, otherwise suppress.

Hope that makes sense.

you can also do a group select to exclude the group from the report on that same condition.
Just be aware for either that the hidden or group excluded data is still part of your data set for sums or counts or whatever.