AnsweredAssumed Answered

Calculating, Summarizing and Reporting Portals

Question asked by KevinO'Neill on Feb 1, 2012
Latest reply on Feb 29, 2012 by philmodjunk

Title

Calculating, Summarizing and Reporting Portals

Post

Greetings

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.

 

 

Picture_7.jpg

Outcomes