Conditional field still displays on report

AlexWiley

I have two fields on a report that I only want to display if there is information. One is a column in the body, and one is a field in the header. I coded them both the same way, but only the column disappears- the field in the header displays regardless. I don't understand what I'm missing...

In the Sales Invoice Header- OnAfterGetRecord I have:

POHeading := '';

and

IF ("Sales Invoice Header"."Your Reference" <> '') THEN
POHeading := AWWText2;

Even when the Your Reference field is blank, the AWWText2 still appears. If anyone has any input I would greatly appreciate it!

matttrax

Whenever I run into a problem caused by something being blank / not blank I add a message box to display the text AND the length of the test. You never know if someone entered a space or something.

You can also export your object to text and make sure you're not setting the POHeading value anywhere else accidentally. Could have left some debug code in there.

AlexWiley

That was it, another developer had referenced that same field. Doh! Thanks for the tip!

Slawek_Guzek

matttrax wrote:

Whenever I run into a problem caused by something being blank / not blank I add a message box to display the text AND the length of the test. You never know if someone entered a space or something.

Actually this is very good troubleshooting tip - you should publish it in Tips & Tricks...