suppress issue with detail/group data

[aspnetuser]

I need to suppress a text box in the group footer area based on IDs in the detail section.

details
ID
A
D
C
E

GROUP FOOTER
TEST BOX

The problem is, I need to suppress ONLY IF THEIR IS AN "A" in the details section.
I tried IN, LIKE, startwith, etc and they fail because it is not searching through the detail records, it is only looking at one value since we are in the group footer.

is their another formula to do this?

 

[TheBlondOne]

I think that theres possibly 2 ways of doing this, firstly you could try using a manual running total and only get it to count if the field = 'A' and then suppress depending on the result of the running total. The other way is to put the information into an array and then search the array for the A. I think i'd try the running total one first as that appears as though it would work.

HTH

 

[lbass]

You could use the running total approach, or you could create a formula {@hasA}:

if {table.ID} = "A" then 1 else 0

Then for your suppression formula use:

sum({@hasA},{table.groupfield}) > 0

-LB