Re: Format Trigger in Reports 2.5

It appears to me that you are actually referencing the layout object (the field itself) in your PL/SQL code when you should actually be referencing the source of that field. For example, if you are using the default naming conventions your field object 'F_addressline2' actually sources a DATABASE COLUMN named 'addressline2' (the 'F_' portion signifies the name of a field layout object and the 'addressline2' portion refers to the data source).

Your PL/SQL IF...THEN conditional should check against the field source 'addressline2' instead, that will remove the bad bind variable error message.

Your code should be:

       IF :addressline2 IS NULL THEN
               return (FALSE);
       ELSE
               return (TRUE);
       END IF;

Hope this helps...

Robert D. Yexley wrote:
>
> HELP!! I am trying to put a format trigger on a field in the layout
> of my report and it's not working. I put an explicit anchor between
> two fields that collapses vertically when the parent object is NULL.
> That alone didn't work. The documentation that I have tells me that
> conditional display of an object is controlled by PL/SQL. The only
> thing that I can figure is that that means putting a format trigger on
> the parent object. The problem comes when I write the trigger, the
> compiler doesn't recognize the name of the object!! Maybe my syntax
> is incorrect. Please help. If I write :
>
> IF :F_addressline2 IS NULL THEN
> return (FALSE);
> ELSE
> return (TRUE);
> END IF;
>
> it tells me that F_addressline2 is an undeclared bind variable.
>
> I would REALLY appreciate some help with this if anyone out there has
> any suggestions, please let me know. Thanks in advance.
>

  <-- SNIP FOOTER -->  

>
>

-- 
 ___ ___ ___ ___ ___ ____   ___ ___ ___ _  _  _   _  _ ___ ___  ___
| _ \   | _ \ __| _ \   _| | __| __| _ \ \| |/ \ | \| |   \ __|/ __/
|  _/ | | _ < _||  _/| |   | _|| _||  _/    | _ \|    | | | _| \__ \
|_|_\___|___/___|_|_\|_|   |_| |___|_|_\_|\_|/ \_\_|\_|___/___|/___/

********************************************************************
        Robert Fernandes - LLNL AIS Dept

        Phone:  (510) 423-1397     Fax:  (510) 423-5882
        Email:  rfernand_at_llnl.gov - or - fernandes6_at_llnl.gov
********************************************************************