I have attached a report I created that shows how many sheets of a colored material will be needed to create a specific number of cuts of a certain size. What I can't figure out is how then to create a report that shows the total number of sheets per color for all sizes.

The "# of Cuts" field is a summery field and the "Sheets" field is a calculation based on the "# of Cuts" field that does the math to find how many sheets are necessary.

Hope this makes sense.

2.pdf

Edited January 29, 200916 yr by Guest

Can't you just create a sub-summary part on your report and place the color field there together with a total of summary type field you create to add the number of sheets?