Here is the screenshot of the layout mode.. notice that the supplies and labor is in the trailing grand summary, if I put all of these fields above the BODY into the leading grand summary for some reason the labor and supplies shows up!!
You are listing multiple records in your report.
Is Supplies Total a number field, a calculation field or a summary field?
I can see that "new total labor" is from a related table. What is the relationship that links this field's table to your layout's table?
A possible explanation as to why they appear in the leading grand summary and not the trailing grand summary may be that Supplies Total is a number field and that this value is stored in the first record in your found set. In similar manner, the relationship to the table were "new total labor" is located may only be valid for the first record in your found set.
Thanks for the prompt response!
I changed those two fields from a number to a calculation and now it seems to work! This brings up 1 more question, how can I get the space between the body to print more closely after each line is printed. Here is a snapshot of what I mean.. Sorry for the bad drawing, the arrow points to the spaces in the body that I want to bring closer.
I got that working too, thank you for your time!