Question Re: Crystal Report help! in CRM and CX Q&A

Crystal Report help!

YL1008 — Fri, 17 Jan 2025 16:44:24 GMT

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.

Re: Crystal Report help!

DonWilliams — Sat, 18 Jan 2025 14:15:36 GMT

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

Re: Crystal Report help!

YL1008 — Mon, 20 Jan 2025 14:01:39 GMT

does it sound right?

Re: Crystal Report help!

YL1008 — Mon, 20 Jan 2025 14:01:51 GMT

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}

Re: Crystal Report help!

DonWilliams — Tue, 21 Jan 2025 01:16:19 GMT

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