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'?

Report message to a moderator

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: 21823
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');

Report message to a moderator

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

Report message to a moderator

Previous Topic: How to get length of column data in oracle form
Next Topic: Arabic Report Problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 20:39:29 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.