I have a report where I am trying to find a total of values based off of another running total. I'm looking to add up all the work hours of a job if it falls within a set of dates, but if it was worked on outside the dates as well as inside the dates then include the outside dates as well. For example, there is a job that was worked on in January and February, I would like to ensure that the January numbers are added as well as the February. Here are some pictures of my data: enter image description here
The far 1 or 0 is if the work date is within the date range I've selected (basically a true false but wanted to be able to maximum). Ideally I would be able to add together the jobs that feature a 1, but that's not possible. I'd like to have a running total of the jobs that include the date, or sum the jobs based on a factor, but I'm not sure how to do that.
It's basically doing a running total of a running total, but wondering how to enter that. Alternately I think it would work if I was able to do a running total on the change of a group and also from a formula, but again I'm not sure if that's possible.
My goal is to simply total the numbers present on this screen but can't figure the formula out: enter image description here
Another solution I've thought of but can't figure out is to turn the first date of the job when it was worked on to the last time it was worked on into a date range, and then if there's a date or dates inside that range that match the date parameter I've made then it adds it to the sum
I have a report where I am trying to find a total of values based off of another running total. I'm looking to add up all the work hours of a job if it falls within a set of dates, but if it was worked on outside the dates as well as inside the dates then include the outside dates as well. For example, there is a job that was worked on in January and February, I would like to ensure that the January numbers are added as well as the February. Here are some pictures of my data: enter image description here
The far 1 or 0 is if the work date is within the date range I've selected (basically a true false but wanted to be able to maximum). Ideally I would be able to add together the jobs that feature a 1, but that's not possible. I'd like to have a running total of the jobs that include the date, or sum the jobs based on a factor, but I'm not sure how to do that.
It's basically doing a running total of a running total, but wondering how to enter that. Alternately I think it would work if I was able to do a running total on the change of a group and also from a formula, but again I'm not sure if that's possible.
My goal is to simply total the numbers present on this screen but can't figure the formula out: enter image description here
Another solution I've thought of but can't figure out is to turn the first date of the job when it was worked on to the last time it was worked on into a date range, and then if there's a date or dates inside that range that match the date parameter I've made then it adds it to the sum
Share edited Mar 6 at 20:22 user29920292 asked Mar 6 at 20:19 user29920292user29920292 11 bronze badge 1- Do you really need an answer for all three Crystal Reports versions? If you mean "any" version, just select the general tag without version. – Sandra Rossi Commented Mar 8 at 8:03
1 Answer
Reset to default 0Crystal Reports alone can't do a total of totals. But at least one of the 3rd-party Crystal Reports User Function Libraries (UFLs) listed by Ken Hamady here provides a set of functions that allow Crystal formulas to compute totals of totals.
If you'd like to create such a UFL on your own, here's a good resource.