Calculating, Summarizing and Reporting Portals
I am trying to report or summarize or calculate portal rows. Here is the deal:
I am a printer. We print large graphics. I have created a portal that tracks these graphics per job. An image showing an example of 1 job is attached.
Graphics use the following materials:
1. Substrate (the surface its printed on)
2. Lamination (protective covering over printing)
Different Lams and Substrates can be used on each.
I need to get the foloowing :
Total square feet used of each Substrate
Total linear feet used of each Substrate
Total square feet used of Lam
Total linear feet used of Lam
I figure I only need to enter the width and height once. Then FM needs to group all the substrates by name and the total sq ft and linear feet used. Then do the same for the Lams.
The Tiles and Rotate fields are only needed to calculate the sq and lin feet so i don't think that is my issue.
So I tried reports but i don't see how on a report I can get two different bodies. 1 for Substrates and 1 for Lams.