AnsweredAssumed Answered

Sub Summary  Report  - 2 problems I'd like some help with.

Question asked by TigerKim on Jan 23, 2009
Latest reply on Feb 5, 2009 by TigerKim

Title

Sub Summary  Report  - 2 problems I'd like some help with.

Post

I've created a Summary Report of my Work Orders using Sub Summary Parts.

The Summary Report looks something like this:

 

 

1. Film Title                                   

    2. Service Type (HD, SD)----------4.Total#of ServiceType (HD,SD)-----5.Total Amount = (Total#ofServiceType  X  )

         3.Spot/Clip Title                                                                                                      Service Rate Price        )

 

 

Firstly, I can't get 5. "Total Amount" to work correctly. The only thing I can think of is using a Calculation Field but it won't work. Sometimes the Amount number is off by +1000 for some reason.

 

Secondly, how do I get the Summary Report to list everything with SERVICE TYPE (HD) and then continue listing for the same FILM TITLE but with SERVICE TYPE (SD)? 

 

Thank you Filemaker Pro Masters for any and all help.

 

Tiger KIm

 

Outcomes