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
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
