displaying if fields are not blank

[kokiri]

Please help. This is the current format:

line1 rn_type r_staff r_hrs r_shift
line2 contractor name1 12 1

line3 lvn_type l_staff l_hrs l_shift
line4 contractor(o) name1 8 2

If line4 is null(all 4 fields), I do not want line3 & line4 to be display.

Any suggestions? Thanks is advance.

kokiri

 

[nagornyi]

Put each line into separate frame with variable vertical elasticity, and conditionally suppress the frames in their format triggers based on condition of the 4th line fields to be nulls.

 

[kokiri]

Hi Nagornyi,

Thanks for your prompt response. I followed your suggestion, but I don't I'm doing it correctly.

In Line3 frame, this is what I have but it doesn't work. What am I missing?

function M_2FormatTrigger return boolean is
begin

if (LVN_TYPE IS NULL) and
LVN_STAFF IS NULL) and
LVN_HRS IS NULL) and
LVN_SHIFT IS NULL))
then
return (FALSE);
end if;

return (TRUE);
end;

Thanks.

 

[nagornyi]

Very small correction:

function M_2FormatTrigger return boolean is
begin

if (LVN_TYPE IS NULL) and
LVN_STAFF IS NULL) and
LVN_HRS IS NULL) and
LVN_SHIFT IS NULL))
then
return (FALSE);
else return (TRUE);
end if;

end;

This condition put also in the format triggers of other lines' frames.

 

[kokiri]

Hi Nagornyi,

Thanks for your correction, I applied your change to Line 3 and line 4 frames but It didn't change anything.
Line 3 title still shows even there is no data in line 4.

I wonder whatelse is missing...

Thanks.

 

[nagornyi]

How do you know the fields are NULLs, but not, for example, blanks? Try going into "Value if Null" property of each field and setting the value it will display if the field is really NULL, for example, the value to be ABC.
Now, is ABC displayed in all fields you believe are NULLs?

 

[kokiri]

Hi Nagornyi,

Thanks for pointing out nulls vs blanks. It works!

Thanks bunch and have a great New Year!!