Home » Developer & Programmer » Reports & Discoverer » REP-1314 Format Trigger 'xxx' references column 'zzz' at a wrong frequency (Oracle 10g Windows XP SP2)
REP-1314 Format Trigger 'xxx' references column 'zzz' at a wrong frequency [message #346024] Fri, 05 September 2008 11:24
Smash
Messages: 18
Registered: August 2008
Junior Member
Hi
In the beginning let's say I'm not an expert in Oracle Reports.
I've created a simple query (in scott schema)

Select * from emp


and a Format Trigger on SAL column.

function B_SALFormatTrigger return boolean is
begin
	if :sal >1000 then
		return false;
	else 
	        return TRUE;
	end if;
end;

But the Reports Builder throws an error
Quote:

REP-1314 Format Trigger 'B_SAL' references column 'SAL' at a wrong frequency


I found on google that column should by a ' repeating frame '
but no one says how to change it.

------EDIT------
OK found the anwser.
I tried to create script on column header not on records.

[Updated on: Fri, 05 September 2008 11:39]

Report message to a moderator

Previous Topic: paper layout
Next Topic: Report query required.
Goto Forum:
  


Current Time: Wed Nov 27 00:46:21 CST 2024