Hi Sonar
Thanks so much for your effort in helping and your example.
Yes I am afraid you misunderstood me.
I want the report to one format with a box when a value is X and another format of the band when value is Y.
Your example shows all of data on one format of band first and then the same on format second.
What I want to achieve is:
Record 1 Format 1 due to value = x
Record 2 Format 1 value x
Record 3 Format 2 value y
Record 4 Format 1 value x
Thanks I will try to find a way.