I knew there had to be a simple answer. I have not used the DBCALC much so I was not sure of the options on right click.
That did it DAN. Thanks Jim ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Dan Goldberg Sent: Thursday, March 12, 2009 12:47 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: SIMPLE QUESTION Right click on it and select calculations. You can change it to count,average,etc. Also, you can set the reset on a break as well. Dan ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Thursday, March 12, 2009 10:19 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: SIMPLE QUESTION I had the var reset already and the var are in the proper break. As for the DBCAL, it comes up with the sum function, but how do you change it to COUNT? Jim ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Javier Valencia Sent: Thursday, March 12, 2009 11:57 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: SIMPLE QUESTION Make sure that you select "Report" from the top menu and then 'Breaks." Highlight the break where you want to reset/recalc the variables, click on the "Reset Vars" button on the right side of the window and enable the variables you want reset/recalc. That should force the recalculation that you need. Javier, Javier Valencia 913-915-3137 ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Thursday, March 12, 2009 11:41 AM To: RBASE-L Mailing List Subject: [RBASE-L] - SIMPLE QUESTION I just converted a simple report to 7.6. For some reason my COUNT var will not reset. They reset just fine in 6.5. Below are the var. COUNT_OF_PROMOID = (ifeq(.COUNT_OF_PROMOID,NULL,0,.COUNT_OF_PROMOID) + 1) COUNT_OF_PROMOCAT = (ifeq(.COUNT_OF_PROMOCAT,NULL,0,.COUNT_OF_PROMOCAT) + 1) The var are in the detail section and the breaks are on the PROMOID and PROMOCAT I know it must be simple but your help would be appreciated. Jim
