Hello all

I've a problem with the conditional print of a box

In the details section of the report I can have many entries and one of them is i.e. "Apple" so:

1 Orange
2 Tomato
3 Apple

Those value can be there or not so in some case I can have only point 1 and 2

In the footer section I've a box that have to be printed only if in the details there is "Apple" code.

I've tried to put in the suppress section of the box this code

if trim({tablefield.tablefield}) = 'Apple' then
    false
else
    true

And is working, but only if the "Apple" value in the details section is the last line. If I have

1 Apple
2 Orange
3 Tomato

The box doesn't appear

I need that the box appear if the "Apple" code is in one line of the details section regardless if is at 1st, 2nd, 3rd or wherever.

It is needed that the box is in the footer section and cannot be in the details because in this last way it will be printed each line.

Any idea?

Thank you in advance for answers

Edited by nalfein - 29 Oct 2009 at 2:14am

Sorry I've not understood where exactly in the header I've to put this formula.



And this one too in the details



I've also another box in the footer if I put this code in the footer suppression formula I will suppress also the box, can I put this code in the suppress section of the single box?

Thank you for answers ))
[/QUOTE]

When i try to create a formula with syntax

shared booleanvar apples:=false;

The system says that "A variable name is expected here"

I've substitued apples with the real value of the variable but it seems to be useless