Dick if you have to give the alternative because right now it evaluates properly the first time and shuts it off from here on out.
Try IF vLineStatus IS NULL THEN PROPERTY idstatus VISIBLE 'FALSE' ELSE PROPERTY idstatus VISIBLE 'TRUE' ENDIF Jan -----Original Message----- From: Dick Fey <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Thu, 04 Mar 2010 12:06:00 -0600 Subject: [RBASE-L] - Re: Hiding Fields in a report That seems to work, but status lines go invisible for all lines regardless of status.. Tried adding else property idstatus visible 'true' but no luck. [email protected] wrote: > Dick, > > You need to define a variable that represents linestatus, and use that > in your eep instead of the column name. > > variable: vlinestatus = (linestatus) > > EEP: > > IF vlinestatus is NULL THEN > PROPERTY idstatus VISIBLE 'FALSE' > ENDIF > RETURN > > > Dawn Hast > > Office - (828) 646-2669 > Cell - (828) 246-8543 > > > > [email protected] wrote on 03/04/2010 12:48:30 PM: > > > Dick Fey <[email protected]> > > Sent by: [email protected] > > > > 03/04/2010 12:49 PM > > > > Please respond to > > [email protected] > > > > To > > > > [email protected] (RBASE-L Mailing List) > > > > cc > > > > Subject > > > > [RBASE-L] - Hiding Fields in a report > > > > I have a report (customer invoice) with fields in the detail band for : > > a LABEL FIELD 'Item Status:' component id is 'idstatus' > > a DBText Field 'DeliveryStatus' component id is 'idstatus' > > > > On some orders there is tax or freight, and I would like for the 2 > > fields not to print as there is no delivery status on those items. > > > > In the detail band, I have an before generate EEP: > > > > IF linestatus is NULL THEN > > PROPERTY idstatus VISIBLE 'FALSE' > > ENDIF > > RETURN > > > > Those fields still print. > > What am I doing wrong? > > > > Dick Fey > > Carpet Broker Inc. > > > > \ > > > > > /DISCLAIMER: This electronic message together with any attachments is > confidential. If you are not the intended recipient, do not copy, > disclose or use the contents in any way. Please also advise us by > return e-mail that you have received the message and then please > destroy. Evergreen Packaging is not responsible for any changes made > to this message and / or any attachments after sending by Evergreen > Packaging. We use virus scanning software but exclude all liability > for viruses or anything similar in this email or any attachment./
