Home » Developer & Programmer » Reports & Discoverer » format trigger ' M_4 ' references column ' CF_SEG ' at wrong frequency
format trigger ' M_4 ' references column ' CF_SEG ' at wrong frequency [message #657764] Tue, 22 November 2016 02:49 Go to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
Hi All,

I have created CF column in G_MAIN group
        SELECT nvl(ATTRIBUTE3,'XX')
        INTO   l_item_seg 
        FROM   mtl_customer_item_xrefs_v 
        WHERE  customer_id = :cust_id 
               AND inventory_item_id = :inventory_item_id 
               AND inactive_flag = 'N';
And need to use in MAIN section format trigger , but it was saying format trigger ' M_4 ' references column ' CF_SEG ' at wrong frequency

function M_5FormatTrigger return boolean is
begin
  if :CF_SEG='TEST' then
  return (TRUE);
  else
  	return (FALSE);
  end if;
end;

Can u please help us on this?

Oracle Reports 10g
Re: format trigger ' M_4 ' references column ' CF_SEG ' at wrong frequency [message #657786 is a reply to message #657764] Tue, 22 November 2016 14:36 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Move CF column into a group that is contained within the M_4 frame.
Previous Topic: SUM instances between 2 values
Next Topic: form6i not open the report
Goto Forum:
  


Current Time: Thu Mar 28 04:15:15 CDT 2024