AnsweredAssumed Answered

Generating a report

Question asked by PatrickFellows on Dec 12, 2013
Latest reply on Dec 15, 2013 by philmodjunk


Generating a report


     Hello i am a quiet the Filemaker novice, but slowly getting what I need to accomplish done. 

     What is causing me difficulties currently is the report im attempting to create. 

     On the main layout where majority of data is displayed i'll have up to 5000 records. 
     These records all represent cattle. 
     They come from a variety of different vendors (previous owners). 
     When we recieve the animals they have a NVD with them (piece of paper with an individual number, a packing slip for transport for lack of a better description).
     This along with the type (male, female, young female) and other details are imported onto the main layout.

     The report im trying to generate, will look something like this.

     Type (all of this type)
               NVD       Vendor         Total on NVD
               NVD       Vendor         Total on NVD     

     Type (all of this type)
               NVD       Vendor         Total on NVD
               NVD       Vendor         Total on NVD     

     For example


               111       Bob         5
               333       Jane        11     

               111       Bob         6
               222       Jill        12     


     I can get it to generate the report on a basic level, where i encounter problems is when their is both Males and females on the same NVD. 

     If there is both males and females it wont populate both Type subsections of the report correctly. 

     There is only ever one vendor per NVD, but can be multiple types. 

     I hope i have given you enough detail to assist me in fixing my problem.