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)
Changes in Report field at run time using trigger [message #525617] Tue, 04 October 2011 02:35 Go to next message
hissam78
Messages: 113
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
Re: Changes in Report field at run time using trigger [message #525639 is a reply to message #525617] Tue, 04 October 2011 07:01 Go to previous messageGo to next message
Littlefoot
Messages: 21547
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;
Re: Changes in Report field at run time using trigger [message #525825 is a reply to message #525639] Wed, 05 October 2011 23:37 Go to previous messageGo to next message
hissam78
Messages: 113
Registered: August 2011
Location: PAKISTAN
Senior Member
thanx little foot
problem resolved

shafiq
Re: Changes in Report field at run time using trigger [message #525851 is a reply to message #525825] Thu, 06 October 2011 04:37 Go to previous message
cookiemonster
Messages: 13864
Registered: September 2008
Location: Rainy Manchester
Senior Member
You could also do the case statement directly in the report query and not bother with a formula column.
Previous Topic: REP-1223: Invalid page size
Next Topic: Oracle Developer Suit Report Problem
Goto Forum:
  


Current Time: Tue Mar 31 06:05:44 CDT 2020