AnsweredAssumed Answered

Trying to separate out a repetition field within a report???

Question asked by SethSantoro on Feb 10, 2011
Latest reply on Feb 10, 2011 by SethSantoro

Title

Trying to separate out a repetition field within a report???

Post

Help?

I am trying to subtotal a report by "Awards": Gold, Silver, Bronze, etc...and then separately by "Competitions Entered".

The problem is, the field itself "Awards"  (as well as "Competitions Entered" are value lists) and have been formatted as a repetition fields.  Meaning, i can put in up to 50 different award competitions entered as well as have one up to 50 awards for all competitions. 

However, when i try and create a report using those field names: "Awards" and "Competitions Entered", the report only shows the first competition or the first award won...what happened to all of the others...

and if i ever want to sort by Golds, Silvers, and Bronzes...how is it going to pick up that information?

Help...?  i hope i have been clear...

any advice would be greatly appreciated...

Outcomes