How to suppress Line in Crystal

[Former Member]

Hi,

I am new to crystal and need to suppress item codes on a quote that are not set as property 63. We create a formula:

If {oitm.qrygroup63} = 'Y' then true else false

This is however not resulting in the desired result.

Your quick assistance will be much appreciated.

Thanks

Jacques

[Former Member]

hi,

you can't suppress line in crystal using formula. You can use "Box" instead of "Line". You can use "Box" like "Line" by working with border. If you want to know more details, please let me know.

best regards,

zzymt

[former_member541807]

Hi Jaques,

you have 2 options.

1st is to display all the items in the OITM that meet your requirement

to achieve this pls. follow this one.

1. from you CR IDE goto Reports -->> Select Expert -->> Record

2. the formula workshop opens, then put this formula

{OITM.QryGroup63} = 'Y'

3. save

4. view the report

5. done

2nd is to set the supress formula

for the suppress, follow this steps

1. from your CR IDE select the Itemcode Field in your report

2. right click select format field

3. Goto Commong Tab

4. press the x+2 button next to Supress

5. please use the ff. Fomula

if {OITM.QryGroup63} = 'Y' then true 
else
false

6. press ok Button

7. save

8. preview the report

Note. this will only Supress the Itemcode field and do not include other fields, if your wish all the items in the details section will be supress too, then repeat the steps from 1 - 6.

regards,

Fidel

[Former Member]

Hi Jacques,

Only if your entire detail line with only OITM data, this is possible. In other word, it may not be realistic to suppress the line just base on this term. You may use query command to remove all those lines by hard coded condition.

Thanks,

Gordon