Thanks Razzak, Get the following when I try to put this in as a variable in the report.
-ERROR- Column PON not found (2369) Layout Print style Go to Variables Draw Manage report Exit »▒╔═════════════════════════════════════════════════════════════════════╗..♦. ║ ║ ║ Define expression: ║ ║ Discount = Discount_Amt IN Cust_Discount WHERE CustNub2 = ║ ║ CustNub2 AND PON IN (SELECT PON FROM Charges WHERE ChargeType ║ ║ IN (31,32)) ║ ║ ║ ╔╚═════════════════════════════════════════════════════════════════════╝ING P╔═══════════════════════════════════════════════════════════════════════════╗ P║ 1: TEXT : D : ADDRES1 = ADDRESS1 IN CUSTOMER WHERE ║ P║ CUSTNUB2 = CUSTNUB2 ║ P║ 2: TEXT : D : ADDRES2 = ADDRESS2 IN CUSTOMER WHERE ║ P║ CUSTNUB2 = CUSTNUB2 ║ P║ 3: TEXT : D : MAC = MACOLA IN CUSTOMER WHERE ║ P║ CUSTNUB2 = CUSTNUB2 ║ P║ 4: TEXT : D : CUSTCTY = CUSTCITY IN CUSTOMER WHERE ║═ P║ CUSTNUB2 = CUSTNUB2 ║ P║ 5: TEXT : D : CUSTST = CUSTSTAT IN CUSTOMER WHERE ║ P║ CUSTNUB2 = CUSTNUB2 ║─ H╚═══════════════════════════════════════════════════════════════════════════╝ D │ -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Monday, March 09, 2009 2:05 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Report variable ? At 01:43 PM 3/9/2009, Steve Breen wrote: >This will not work > >Discount = Discount_Amt in Cust_Discount Where CustNub2 = CustNub2 and >PON in (Sel PON from Charges where ChargeType = 31 or ChargeType = 32) Steve, Try the following expression and see what you get. Discount = Discount_Amt IN Cust_Discount WHERE CustNub2 = CustNub2 AND PON IN (SELECT PON FROM Charges WHERE ChargeType IN (31,32)) Very Best R:egards, Razzak.
