Re: Reports 6i ???
From: Frank <frankbo_at_interaccess.nl>
Date: Tue, 24 Oct 2000 15:02:31 +0200
Message-ID: <8t419j$hvk$1_at_porthos.nl.uu.net>
Date: Tue, 24 Oct 2000 15:02:31 +0200
Message-ID: <8t419j$hvk$1_at_porthos.nl.uu.net>
are there other values that NULL and 'X' in the database? If so, what is the value of Other Values?
-- Frank Richard Hollingsworth <william.hollingsworth_at_hsv.boeing.com> schreef in berichtnieuws 39F4B598.57B34A4C_at_hsv.boeing.com...Received on Tue Oct 24 2000 - 15:02:31 CEST
> Hi folks. Thanks for reading this.
>
> I have a question about a report I've built in Reports 6i, Oracle 8i,
> Win NT 4.0.
>
> I have a series of checkboxes on the printout. The database fields for
> each check box are varchar2(1). On the FORMS input screens, I have set
> ...
>
> Value when checked = 'X'
> Value when unchaecked = NULL
>
> Now, when I run the report, IF the value of the checkbox is 'X', it
> prints out an 'X' just like planned.
>
> However, if the value of the checkbox is NULL, it prints out a '0'.
>
> If the value of the chaeckbox is NULL, I want REPORTS to print out a
> NULL or a ' ' (blank) , either one. Therefore, the item will appear
> either with an 'X' if checked, or NOTHING if not checked.
>
> Anyone know how to remidy this situation??
>
> Thnaks,
> Richard Hollingsworth
>