Now that I changed the join, everything is working fine, except one last item. It now doesn't let my @CAC subtotal fields work.
They were set up as running totals, and the @CAC formula was:
ToNumber ({JC_CONTROLESTIM.USER2})
However, now it says "The String is Non Numeric" when you print. If I eliminate the ToNumber from the formula, then I can't get the Subtotal to work.
The @CAC represents the Cost At Completion field and is a custom field on the Cost code. It is not specifically a numeric field which is why I was trying to convert it to one.