what is your ZERO setting? if ZERO is ON a null integer will evaluate to zero and thus not test as nulll test for both null and zero
Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Bruce A. Chitiea Sent: Tuesday, February 11, 2014 2:23 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Report Region Refuses to Disappear No effect. But here’s a thought. This is a Chart of Accounts, in which the *non-regioned* DBLabels display just fine from integer values. Do the variables used to test for NULL in the *regioned* DBLabels held in the regions need to convert the integer value to text, e.g.: (CTXT(glCodeNUM3)) Thanks, Bruce From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Bruce A. Chitiea Sent: Tuesday, February 11, 2014 10:24 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Report Region Refuses to Disappear Jan: Hmmm. I’ll give that a shot. Thanks again, Bruce From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of jan johansen Sent: Tuesday, February 11, 2014 9:29 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Report Region Refuses to Disappear Bruce, I think I've run into something like this before using a report variable. I think it's a chicken and egg thing. When does a report variable get evaluated? You may want to move it from a report variable to a before generate eep. Jan -----Original Message----- From: "Bruce A. Chitiea" <[email protected]<mailto:[email protected]>> To: [email protected]<mailto:[email protected]> (RBASE-L Mailing List) Date: Tue, 11 Feb 2014 09:20:41 -0800 Subject: [RBASE-L] - Re: Report Region Refuses to Disappear Jan: I agree: that solves the visual display of ‘-0-‘. The additional requirement is to release the vertical space, so as to not leave wide gaps between visible lines. Thanks much. Bruce From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of jan johansen Sent: Tuesday, February 11, 2014 9:14 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Report Region Refuses to Disappear I normally in the before report opening eep I normally use SET NULL ' ' and then on report close SET NULL -0- -----Original Message----- From: "Bruce A. Chitiea" <[email protected]<mailto:[email protected]>> To: [email protected]<mailto:[email protected]> (RBASE-L Mailing List) Date: Tue, 11 Feb 2014 09:08:52 -0800 Subject: [RBASE-L] - Report Region Refuses to Disappear RBASE 9.5(64) Latest Problem: Break Header / Region with NULL DBLabel value displays '-0-' and consumes vertical space in report. Want these NULL regions to disappear/collapse. Background: A Break Header contains Region with Component ID: [ ppRegionLevel4 ]. The Region contains DBLabel control: [ glCodeNUM4 ], which displays correct data values. The goal is to have the Region and Break Header disappear/collapse whenever [ glCodeNUM4 ] is NULL. To this end, the [ Before Generate Custom EEP ] for the Break Header is coded: IF vglCodeNUM4 IS NULL THEN PROPERTY ppRegionLevel4 VISIBLE FALSE ELSE PROPERTY ppRegionLevel4 VISIBLE TRUE ENDIF RETURN Report Variable [ vglCodeNUM4 ] is defined as: 2 : TEXT : H4 : vglCodeNUM4 = (glCodeNUM4) What am I missing here? 'Preciate your assistance. Bruce
