If EarnedHours is a column in the view, and you're trying to SUM the column in the report, have you tried using a DBCalc?
Paula Stuart 70 Summer Street Somerville, MA 02143 617-776-3367 617-388-1331 (Cell) [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Lustig Sent: Tuesday, August 24, 2004 10:08 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Unable to create report variable I am getting the error Unable to Create Report Variable (2196) when trying to declare the following variable rvWOEarnedHours = SUM OF EarnedHours The report is based on a view, the view is declared using the syntax that specified column names in parentheses, EarnedHours is a column in the view, it appears correctly on the report when printed, and is used in an expression earlier in the variable list without problem. Any suggestions gratefully appreciated. -- Larry
