I too have found a number of instances in converted reports where the variable field value appears as undefined or blank, yet creating another variable label with the same variable works properly. Replace the old with the new and it works fine - no apparent reason ?
Regards, John Docherty -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paula Stuart Sent: Wednesday, 1 September 2004 12:06 p.m. To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Report expression John, I think it works that way sometimes. It's the software equivelent of kicking something to make it work. No scientific logic...but if your goal is to make it work....who cares? Paula [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Engwer Sent: Tuesday, August 31, 2004 11:18 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Report expression David, I did check 1,2 & 3 and everything looked OK but I must have overlooked something. I deleted the field from the report and then put it back on and it worked properly. I have had similar things happen when I converted reports and forms from DOS 4.5++ (via 6.5). I don't convert anymore; I create a new reports or forms instead. I tried to recreate the problem but I haven't been able to do so. It's probably something that I entered wrong during one of my "all-nighters". John -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David M. Blocker Sent: Tuesday, August 31, 2004 9:35 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Report expression John Check some obvious things 1. is the variable in the list of report variables? 2. Click on the control on the report and look in the upper left corner where the variable asociate with the object is: is it the right one? 3. Check in the list WHEN the variable is calculated. If this is printed for every row, make sure it's calculated at the D = detail level. David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "John Engwer" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Monday, August 30, 2004 8:59 PM Subject: [RBG7-L] - Report expression > I have the following text expression in a report. vDISCOUNT = > (IFGT(DISCOUNT,0,'DISCOUNTED',null)) > The expression displays "DISCOUNTED" in the line item receipt if the > purchase was discounted. The field DISCOUNT is a currency field > This expression works OK in DOS version 4.5++ > > No errors are reported when the expression is created but it prints > (NOT > DEFINED) instead of DISCOUNTED. > > Is there something wrong with this expression? Is it a problem that > the field DISCOUNT is currency and the variable vDISCOUNT is text? > > John > >
