Generate a Number List in a Sub-Summary Part that will Restart
I am trying to get groups of students numbered into separate cabins so that it would be #1, 2, 3, etc... in each cabin.
I would like to have my number list restart after each sub-summary occurance. I created the summary field <<List Number>> to count the <<Student Last>> field in a sub-summary part when sorted by <<ID Cabin pk>>. I thought that selecting Running Count and Restart summary for each sorted group would restart the numbering for each list, but it is creating sequential numbers from cabin to cabin.