If the report really has the “**ENDOFREPORT** line after the Final totals count, then the following will work.
1. Create the Detail template as you have it. As you say, this will give the total count as well.
2. Create an append template using the same sample and trap as you choose for the detail. And highlight the count field again. You will see all the counts highlighted once more. Call the new field total for example
3. Double click on the field above and go to the advanced options. Use a preceding string of ***. When you preview, you should see that only the end or report line has a highlight.
4. Make sure the new field is character and you should end up with a table like this (from the example you gave)
The D is the text from the end of report line. It doesn’t matter if it’s something else as long as that in the only row that has something in.
5. Create a filter using the expression IsBlank(totals)
Alternatively, you may be able to cheat!!! Your text says that the count line is identified as Count ## (.i.e. only two digits). If this will always be the case, and your totals will always be over 100, you could use a filter of count<100. A bit of a long shot but worth a mention.
In addition to the above suggestions, you can also try the following:
1. First, I assume you are trapping the COUNT figures as your Detail template.
2. Create an Append trap, using two lines, such as:
Use the second line for your trap (ie the word COUNT) and paint FINAL TOTALS as your append level field. Call it COUNT INFO.
3. In your Table view, create a filter as follows:
COUNT INFO<>"FINAL TOTALS" to remove fron your table that last row of data with the final total count.
Reply back and let me know if this works,