Sub Summary Report - 2 problems I'd like some help with.
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.