OraFAQ Forum: Reports & Discoverer » 2 query -- I want to hide a item from 1 query

Home » Developer & Programmer » Reports & Discoverer » 2 query -- I want to hide a item from 1 query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

2 query -- I want to hide a item from 1 query [message #233414]

Thu, 26 April 2007 01:37

kamran.it
Messages: 265
Registered: September 2005
Location: Karachi

Senior Member

I have 2 query
1st query items : srno, color1, color2
2md query item : srno, qty1, qty2

Now i want to create a logic if color2 is null then hide qty2.
I wrote a code in qty2 PL/SQL editor

if :color2 is null then
return (false);
else
return (true);
end if;

it compiles successfully but show the error when run

Rep: 1314: Format Trigger 'F_qty2' reference column 'color2' at wrong frequency.

please reply in detail

Report message to a moderator

Previous Topic:	Freight Charges not appearing in Order / Invoice Detail Report
Next Topic:	Changing Field's Value at RUNTIME

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 26 11:39:29 CST 2025