how to format a report [message #502975] |
Tue, 12 April 2011 00:11 |
|
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 |
|
Littlefoot
Messages: 21818 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:(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
|
|
|