Home » Developer & Programmer » Reports & Discoverer » report
report [message #283885] Wed, 28 November 2007 06:14 Go to next message
syamthampiv
Messages: 16
Registered: November 2007
Junior Member
How can i show a field whose value is Y/N in the report as a check box with checbox ticked if value 'Y' and unticked if value 'N'?
Re: report [message #283902 is a reply to message #283885] Wed, 28 November 2007 06:54 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell, there's no "checkbox" field in Reports Builder. In order to do what you want, create a field whose source is an image: unchecked checkbox for "N" and checked for "Y" (it means you'll have to have two images).

Do not display field whose value is "Y/N"; just display an image (they will, probably, overlap). Create a Format Trigger for the image fields which would look like this (for field's value = 'Y'):
RETURN (:field_YN = 'Y');
Re: report [message #284229 is a reply to message #283885] Thu, 29 November 2007 03:36 Go to previous message
javed.khan
Messages: 340
Registered: November 2006
Location: Banglore
Senior Member

Yes , I agree with that make a JPG by taking a Screen Shot from your any matching GUI(Graphical User Interface ) and Write format trigger on the basis of two values i.e. Y/N.
Jak
Previous Topic: How to get length of column data in oracle form
Next Topic: Arabic Report Problem
Goto Forum:
  


Current Time: Thu Dec 08 02:08:55 CST 2016

Total time taken to generate the page: 0.09117 seconds