Crystal Report help!

[YL1008]

Hello,

We are working on a receiving report to be able to show all part (part number, vendor part number & mfg part number) under the part number field. However, after several attempts of modifications, the field still shows part number only. Please help us on this modifications. Thank you.

1. Change "Exceptions for nulls" to "Default Values for nulls".

2. In the Select Expert, change the part that checks for nulls to this:

(
{PURC_ORDER_LINE.MFG_PART_ID}) <> "" OR
{PURC_ORDER_LINE.VENDOR_PART_ID}) <> "" OR
{PURC_ORDER_LINE.PART_ID} <> ""
)

3. Change the formula to this:

if Trim({PURC_ORDER_LINE.PART_ID}) = "" then
if Trim({PURC_ORDER_LINE.VENDOR_PART_ID}) = "" then
{PURC_ORDER_LINE.MFG_PART_ID}
else
{PURC_ORDER_LINE.VENDOR_PART_ID}
else
{PURC_ORDER_LINE.PART_ID}

the result does not come to be completed again. not sure what else we can do. thank you.

[DonWilliams]

Hello,

CR considers nulls as not blank or empty data.

Hit the F1 key to bring up the Help file and the search on "isnull" for examples on how to

Don

[YL1008]

does it sound right?

[YL1008]

if isnull ({PURC_ORDER_LINE.PART_ID}) then if isnull ({PURC_ORDER_LINE.VENDOR_PART_ID} then {PURC_ORDER_LINE.MFG_PART_ID} else {PURC_ORDER_LINE.VENDOR_PART_ID} else {PURC_ORDER_LINE.PART_ID}

[DonWilliams]

try one thing at a time, you still have to test for the other conditions...