Home » Developer & Programmer » Reports & Discoverer » 2 query -- I want to hide a item from 1 query
2 query -- I want to hide a item from 1 query [message #233414] Thu, 26 April 2007 01:37
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);
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
Previous Topic: Freight Charges not appearing in Order / Invoice Detail Report
Next Topic: Changing Field's Value at RUNTIME
Goto Forum:

Current Time: Sat Oct 22 00:55:25 CDT 2016

Total time taken to generate the page: 0.08214 seconds