Getting a field to appear or print in a list only when the value changes
I have moved over to FileMakerPro (version 11 and considering version 12) from Alpha5 and am having a problem getting printed reports to work as I would like.
With Alpha5 I could design a report and have a field print only when the value changed -- I conduct a large band and am using the database for (among other things) keeping the band's roster. So I have the roster print by instrument, and it seems silly to have 8 lines which all begin with 'Flute' -- in Alpha5 I could get the "Instrument" field to print only when it changed, so that the first flute player would have Flute appear beside the name and then the next 7 wouldn't have anything print in that field and then the first Oboe player would have the word Oboe appear beside the name and the next couple would have that field blank. And so on down the roster -- it makes it look so much nicer.
I have searched and can't find any way to do this with FilemakerPro -- can anybody help me please?