According to one of the help files online NULL can only be used for DATE fields. A blank field is referenced as ""

Here's the link - it's just over half way down

Change the second part to "", ie:

SALES_ORDER.CUST_ORDER_NUMBER="" ? SOP_ITEM.EXT_ORDER_REF : ""

(Using SALES_ORDER.CUST_ORDER_NUMBER for the other field.)

Thanks for that Ken.

Hi Robert,

Thanks for this. It seems to work.

If I needed to hide a text label that relates to the  SOP_ITEM.EXT_ORDER_REF when it is not populated is there a way to do that?

Regards

Andy

There are two possible ways I can think it might be done:

1) Have two different ORDER_NUMBER Header sections, each with a filter:

1st with Filter Expression: SALES_ORDER.CUST_ORDER_NUMBER <> ""

2nd with Filter Expression: SALES_ORDER.CUST_ORDER_NUMBER = ""

with the same information except the headings for the two Fields: remove the field 2 header from the first and remove the field 1 header from the second.

2) Replace the text boxes in the header section with data fields which contain an expression:

Field 1: SALES_ORDER.CUST_ORDER_NUMBER="" ? "" : "Field 1 header"

Field 2: SALES_ORDER.CUST_ORDER_NUMBER="" ? "Field 2header" : ""

We only have service items so don't use despatch notes so I can't test the theory.

Or the 3rd way would be to use conditional formatting. Add a condition for SALES_ORDER.CUST_ORDER_NUMBER = "" and set the suppress printing property to true for this.

Thanks...I'm still learning about report designer...that's the best way!

Hi Darron,

So will this suppress the printing of the label associated with the expression if the expression contains no information? Do I need to put this condition into the conditional formatting section in properties for the label?

Regards

Andy

It would just apply to the element(s) you set it on. So by default just the expression if that is what you have selected at the time you set the conditional formatting. You can of course repeat the conditional steps on the label too or, if you need to do it for several element you can multi select them (drag a box around  them or CTRL + click) and then use the properties window to set the conditional formatting. The changes would then be applied to all selected items and you only have to do it once.

Thanks Darron,

After a bit of trial and error I got this to work based on your conditional formatting suggestion.

Regards

Andy