OraFAQ Forum: Reports & Discoverer » Changes in Report field at run time using trigger

Home » Developer & Programmer » Reports & Discoverer » Changes in Report field at run time using trigger (Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production, winsrv 2003)

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

Changes in Report field at run time using trigger [message #525617]

Tue, 04 October 2011 02:35

hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN

Senior Member

if the date is 01-09-2011 then we want to show 'off' in place of total hours in Report field.
if date is other than 01-09-2011 then we need to show the total hours.
this we want to see on report in report builder at run time. how we can define in format trigger.

shafiq

Report message to a moderator

Re: Changes in Report field at run time using trigger [message #525639 is a reply to message #525617]

Tue, 04 October 2011 07:01

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Well, you could create a formula column (that returns a character value) and display its result as follows:

  retval varchar2(20);
begin
  retval := case when :date_value = to_date('01.09.2011', 'dd.mm.yyyy') then 'off'
                 else to_char(:total_hours)
            end;

  return (retval);
end;

Report message to a moderator