Format Trigger in Reports 2.5

From: Robert D. Yexley <ryexley_at_afit.af.mil>
Date: 1998/02/24
Message-ID: <34f33b14.31517084_at_news.afit.af.mil>#1/1

[Quoted] [Quoted] 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