How to NOT show # if one contains code 1

[ramjones]

I am not a programmer.

I have CR8.5 report that shows in detail section, all open line items of the sales order. If one of the line items contain code 'HH', then I do not want it to show the order # at all.
I thought of whileprinting, but I do not know how to do this right. Thanks In Advance.
Tina

 

[lupins46]

Create a formula field:

@IsHH:
if {mytable.myfield} ="HH" then 1
else
0

Create a group on the order number and insert a summary which sums the formula field.(You can suppress Gp Header and footer)

Now use the Group selection rules to select just those groups which have a sum>0.

 

[Madawc]

You could suppress the line. Right-click on the detail section and choose Format Section. Then choose the formula icon (x+2 and a pencil) for suppression. Enter a formula; e.g.
{containe.code} = 'HH'

If might be better to exclude such records at record-selection time, unless you need them for something else. This would mean that the Server will do the selection, and does it faster than your own machine would do it.

Madawc Williams (East Anglia, UK)

 

[ramjones]

This one fixed my problem. Thank you very much.
Tina
***********************************
Create a formula field:

@IsHH:
if {mytable.myfield} ="HH" then 1
else
0

Create a group on the order number and insert a summary which sums the formula field.(You can suppress Gp Header and footer)

Now use the Group selection rules to select just those groups which have a sum>0.