Hi Dennis,
It always gets deeper and deeper. I have now played with the two reports you suggested.
First let me say I am running 9.0.50. If something in a later version changed any of this let me know and I will get the update.
All Band and Mode SummaryThis report has two problems for my application.
I am quite sure it counts deleted countries in the Fulfilled totals.
It shows a total of 401 countries for the Total DXCC count. I suspect that 4J1 has snuck back into the active list.
All band and mode awards progress -- DXCC ChallengeThis report lists all of the countries and then summarizes the information at the end. Interestingly enough the country count is correct showing 340 countries.
This report will meet my needs. The only problem with it is that it does not total requested QSLs as it should nor does it total Worked no QSL. I have highlighted the attached report.
All band and mode awards progressThis report includes deleted countries (I think). It also has the problem of not totaling requested QSL and it does not total No QSL Sent. The DXCC country count is 341.
I have attached a cards needed report as well. This is accurate in my case for active countries. All of the other reports should show a total mixed confirmed of 328.
A new question comes up as I am gathering this information. How is a country marked as deleted? I have gone to the prefix table and added an end date for 4J1 but that did not make it inactive. I can find nothing regarding this in Help or the manual.
Thanks Dennis, I really appreciate the help on this. As I am approaching the Honor Roll these reports are becoming very important to me. Logic does a much better job of organizing the data than I can do by hand considering I keep receiving new country confirmations on LoTW and therefore pulling the paper cards I need to apply would keep changing. I love the way LoTW keeps track of all of this automatically.