Re: Format Trigger in Reports 2.5

ryexley_at_afit.af.mil (Robert D. Yexley) wrote:

When you are using a format trigger to determine whether a field is displayed or not, you need to use the field from the query, rather than the field on the layout in the IF statement. I am not sure whether this is your problem or not.

>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.
>
>SSgt Robert D. Yexley
>Applications Services Division (SCA)
>Air Force Institute of Technology
>Oracle Database Programmer
>SCA WebMaster
>email : ryexley_at_afit.af.mil
>Voice : DSN - 785-6565 x-4268
> Civ - (937) 255-6565 x-4268
>Fax : DSN - 986-7080
> Civ - (513) 476-7080
>http://sc.afit.af.mil/sca
><)))><
>
>~~~~~~~~~~~~~~~~~~~~~
>"God who gave us life gave us liberty.
>Can the liberties of a nation be secure
>when we have removed a conviction
>that these liberties are a gift of God?
>Indeed I tremble for my country when
>I reflect that God is just, that his
>justice cannot sleep forever."
> - Thomas Jefferson, 3rd US President
>~~~~~~~~~~~~~~~~~~~~~
>
Received on Tue Feb 24 1998 - 00:00:00 CET