I have been asked to modify the Labor Edit Report to show buckets for Indirect labor, Direct labor, Idle time, and pay hours. When I create a calculated field in the ssrs it returns #error. When I try to sum if based off of criteria like LaborType <> “I” then it works at the detail level, but does not sum for totals. Has anyone come up with a way of getting total hours through calculations without the annoying #error message?
One trick is to convert the field to a decimal (even though it is already a number field). I have run into some situations were i have to add a CDec(Fields!OnHandQty.Value).
It can’t hurt - give it a try.
That trick is way out there… but it worked like a charm. Solution to you good sir! Thanks a ton!