Dan, You can assign two aggregate functions with the same sum. Clear one of the variables at the emp breakpoint and the other at jobno breakpoint.
Steve Steve Vellella Office: 520-498-2256 Cell: 520-250-6498 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Champion Sent: Wednesday, January 25, 2006 8:46 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Variable within a report >Hi All, I am having a bit of trouble getting a variable assigned in a report. I am using 6.5++ windows I have a report with two breakpoints, first breakpoint is on EMP (employee), and the second is on JOBNUM (jobnumber) if in the report I assign an aggregate function to find the labor cost of a jobnumber it will find it for just the total cost for that employee. I need that, but I also need it for any employee that worked at that jobnumber. The agregate function assigns the varaible : SUM_OF_lcost = SUM OF lcost (which only gets the total lcost for just the one employee being reported on in that break.) I need something like: tjlcost = (sum) lcost from bluebk where jobnum = .jnum but I can't seem to come up with the right syntax to type into the 'Edit Variables (Define Expression)' box. Any Ideas? Dan Champion www.championsolutions.net 616-299-7420
