OraFAQ Forum: Reports & Discoverer » Group Level Triggers

Home » Developer & Programmer » Reports & Discoverer » Group Level Triggers

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

Group Level Triggers [message #260292]

Sat, 18 August 2007 02:42

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

Report message to a moderator

Re: Group Level Triggers [message #260319 is a reply to message #260292]

Sat, 18 August 2007 06:36

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

You can return FALSE in the format trigger of the repeating frame, when the condition matches. Otherwise return TRUE.

Edit: No idea why do you want to use a cursor, instead of an if clause.

By
Vamsi

[Updated on: Sat, 18 August 2007 06:37]

Report message to a moderator

Re: Group Level Triggers [message #260506 is a reply to message #260319]

Mon, 20 August 2007 03:19

prachi.mgorwadkar
Messages: 75
Registered: May 2007
Location: Pune

Member

Hello,

Thanks for the reply.
But it does not work. As I explained earlier.

And the reason I am using cursor is, I want to check whether this is possible with the cursors?

Thanks,
-P

Report message to a moderator

Re: Group Level Triggers [message #260525 is a reply to message #260506]

Mon, 20 August 2007 04:13

Littlefoot
Messages: 21823
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;

Report message to a moderator

Previous Topic:	dot matrix printing
Next Topic:	graphics builder

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 18:44:56 CST 2024