boolean operation to a field in BMPRDSTR_SQL?

[tomasdebrun]

Hi All,
I have been reading through some old crystal reports and have come across the following formula

Formula nameBOM

IF NOT ISNULL({BMPRDSTR_SQL.item_no})
THEN 'Y'
ELSE ' '

I am not too familiar with this statement can anyone explain what operation does this perform on the data please?

Cheers
tomás

 

[kscheeler]

This looks like a report that is showing which items from the item master file has BOM's in the Product Structure file.

Most likely, the two tables involved are IMITMIDX_SQL and BMPRDSTR_SQL linked on imitmidx_sql.item_no = bmprdstr_sql.item_no

For any further information, it would help to see the thread that it came from.

Kevin Scheeler

 

[maccrystal]

This formula does the following:
if the item number is not a null value it will set the value of @BOM = 'Y' other wise it's value is ' ' or blank value. The isnull function returns a True / false value if the field is null. My guess is the formula was used to determine is a product structure existed for an item, it would print a "Y" on the report.

http://www.appstratinc.com