robertjmackay
asked on
VB.NET 2003 - Crystal Report - select records to be totaled
I have a report that sorts and groups the data by a job number and job type. After each change in group a total line is printed. What I would like to do is have a total for each job type, placed at the end of the report. I tried using a formula field but I am getting zeros. Below is the formula I have been playing with, however, it does not work
Shared numbervar prod;
if {jobhead.DETLSTEPTYPE} = "Production" then
sum({jobhead.DETLSTEPEXTTI ME})
Shared numbervar prod;
if {jobhead.DETLSTEPTYPE} = "Production" then
sum({jobhead.DETLSTEPEXTTI
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome!
ASKER
Is there a way I can have this calculate on the detail liner without actually placing the field there. The detail line is full and in order to put the field there, I had to goto a second line, and adding spaces between the details
I have no way to test it here at the moment, but you can try it without adding the field. It might just work. But you can just suppress the field , or add it to a detail line and suppress the whole line's output.
ASKER
I didn;t have to put it on thde detail line at all. Thanks again .. .well done
No problem :D
ASKER
Thanks
Rob mackay