Larry If I were in your spot I'd try the following
1. CAN I create a DBCalc on the same view column in the report writer? 2. Can I perform a SELECT SUM (colname) FROM viename at the R> prompt? 3. Can I create a lookup variable in a form or report following the same idea? rLookup = SUM(colName) FROM ViewName WHERE.... This will help narrow down what the issue is. Sometimes I get error messages like this because: 1. The view is too complex for R:Base to handle - a view based on a veiw, for example. I may have to insert the first view into a temp table and then do the second view off that table 2. The view in question contains a variable which is not defined at that moment. David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Lawrence Lustig" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Tuesday, August 24, 2004 11:08 AM Subject: [RBG7-L] - RE: Unable to create report variable > > 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? > > (I did solve the problem, see my earlier follow up > post). > > Actually, I was using these variables to REPLACE a > couple of DBCalc components. The reason is that I > need to compute and display an efficiency ratio in the > total line, and there's no way (that I can see) to > extract the SUM information from the DBCalcs to use in > that footer-level calculation. > -- > Larry > > David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Lawrence Lustig" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Tuesday, August 24, 2004 11:08 AM Subject: [RBG7-L] - RE: Unable to create report variable > > 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? > > (I did solve the problem, see my earlier follow up > post). > > Actually, I was using these variables to REPLACE a > couple of DBCalc components. The reason is that I > need to compute and display an efficiency ratio in the > total line, and there's no way (that I can see) to > extract the SUM information from the DBCalcs to use in > that footer-level calculation. > -- > Larry > >
