Thanks all. I did end up using "DB Calc" to eliminate some of the variables.
Happy Friday the 13th to all. Dayle Coxen Florida DOT (850) 410-5635 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Thursday, April 12, 2012 5:33 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Report Variable Sum At 05:00 PM 4/12/2012, Coxen, Dayle wrote: >I am converting a report from 6.5++ to 9.1 (Build 9.1.5.20317) >My report variables don't seem to be working as they did in 6.5. >The report was summing the regular hours worked by employee >(social security number). >The Report variable I am having trouble with is defined as: > REAL : D : r1a = sum of reg1 >reg1 is the table column containing hours worked. >I have a break (Break Footer[0]: ssn) by social security number. >The issue is, the variable r1a displays summed correctly for the first >row of the report. >But subsequent rows in the report, it is displayed as a null value -0-. Dale, Make sure that the variable is calculated for the correct band of the report, i.e. Break Footer [0]. Here's how: 01. While in Report Designer ... Main Menu | Variables | Add/Edit Variables ... 02. Highlight the RLA variable and then select F0 from the list of available options under Calculate On: Click on [Change] button to change. Click on [Apply] button to apply all changes. 03. Save the report. While converting and migrating from 6.5++ to 9.1, you should take advantage of "DB Calc" options in Report. For a sample report to illustrate the difference, take a close look at the "SubTotalsAndTotals" report included with the sample RRBYW17 database and sample application. Good luck! Very Best R:egards, Razzak.
