Group Level Triggers [message #260292] |
Sat, 18 August 2007 02:42 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
prachi.mgorwadkar
Messages: 75 Registered: May 2007 Location: Pune
|
Member |
|
|
Hello,
I have one query as:
I create one very simple report with a query -
select * from emp where job like :ejob;
I want to put a condition with hiredate for a particular Employee, as
if hiredate is null then do not display that whole row of the related employee.
How can I do it?
I have used cursor, but it does not work.
Because in Reports, trigger is nothing but a function form. That must return something.
And as it RETURNs something, the focus goes out of the function & cursor remains open.
Thanks in advance,
-P
|
|
|
|
|
Re: Group Level Triggers [message #260525 is a reply to message #260506] |
Mon, 20 August 2007 04:13 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
I still can't understand why you have to use a cursor; in a report like yours, use repeating frame's FORMAT TRIGGER as Vamsi suggested.function R_G_EMPNOFormatTrigger return boolean is
begin
return (:hiredate is not null);
end;
|
|
|