Home » Developer & Programmer » Reports & Discoverer » how to format a report (reports 10g,Win XP)
how to format a report [message #502975] Tue, 12 April 2011 00:11 Go to next message
maddyd2k
Messages: 24
Registered: November 2010
Junior Member
Hi all
I am beginner to reports working on reports 10g
Actually i have to print addresses of customer on a report. Using one of the layout style i am trying that.
But i have a requirement.
In some province town and city will be same in this case i need to print only the city name. they should not be any town.. How can i format when town field is null then i should not show town in the report???????

Thanks




Re: how to format a report [message #502977 is a reply to message #502975] Tue, 12 April 2011 00:50 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
One option is to create a format trigger on the TOWN field. As it returns Boolean, you should return FALSE if TOWN = CITY. It might look like this:
return (:town <> :city);
(i.e. if those values are not equal, display town field's value).

[Updated on: Tue, 12 April 2011 00:50]

Report message to a moderator

Previous Topic: Converting old 2.5 Oracle Reports to 6i (.rdf)
Next Topic: REP-52251: Cannot get output of job ID 18980 you requested
Goto Forum:
  


Current Time: Thu Mar 28 06:09:54 CDT 2024