Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 240
  • Last Modified:

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})

0
robertjmackay
Asked:
robertjmackay
  • 4
  • 3
1 Solution
 
PockyMasterCommented:
You can create  new value (calculated) which exists for each group, where in you multiply the {jobhead.DETLSTEPEXTTIME} with 1 if DETLSTEPTYPE = production or with 0 if isn't.

Then just sum that value.
0
 
robertjmackayAuthor Commented:
worked, I added the supress property on the detail and worked great
 Thanks
Rob mackay
0
 
PockyMasterCommented:
You're welcome!
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
robertjmackayAuthor Commented:
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
0
 
PockyMasterCommented:
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.
0
 
robertjmackayAuthor Commented:
I didn;t have to put it on thde detail line at all.  Thanks again .. .well done
0
 
PockyMasterCommented:
No problem :D
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now