Trying to separate out a repetition field within a report???
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...