Link to home
Start Free TrialLog in
Avatar of robertjmackay
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.DETLSTEPEXTTIME})

ASKER CERTIFIED SOLUTION
Avatar of PockyMaster
PockyMaster
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of robertjmackay
robertjmackay

ASKER

worked, I added the supress property on the detail and worked great
 Thanks
Rob mackay
You're welcome!
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.
I didn;t have to put it on thde detail line at all.  Thanks again .. .well done
No problem :D