+ AA6YQ comments below
On Thu, Apr 16, 2020 at 3:07 PM Udo A. Heinze <uaheinze@...> wrote:
I am trying to come up with the following report:
I want to see Grid Squares that I have worked but not confirmed in my VUCC.
Specifically I sort my log for say only 6 meter contacts. Then go to the progress tab and hit the Progress Key for VUCC. It gives me all the grids I have on 6 meters, both worked and confirmed.
How do I get to a report that ONLY gives me those grids (and the contact info) that I have worked but NOT confirmed?
Fun! Not sure if there's an easier way, but the following filter should match any 6m QSO where any of the 4 grids is (W)orked. You could then generate a report (keeping the filter in place), or make a script.
Band = '6m' and EXISTS (SELECT VUCCProgress.M6 FROM VUCCProgress WHERE
(VUCCProgress.M6 = 'W' and VUCCProgress.Grid in (Left(Gridsquare, 4), Left(App_DXKeeper_Grid2, 4), Left(App_DXKeeper_Grid3, 4), Left(App_DXKeeper_Grid4, 4))))
Not thoroughly tested, but the result seems reasonable for my log.
+ Alternatively,,
1. On the Main window's "Check Progress" tab, click the VUCC panel's Realtime button to display the VUCC tab of DXKeeper's "Realtime Award Tracking" window
2. In the "VUCC Award Progress Filter" panel on the VUCC tab of DXKeeper's "Realtime Award Tracking" window,
2a. set the Band selector to 6m
2b. check Worked and Requested boxes
2c. uncheck the Confirmed and Verified boxes
2d. click the Report button
+ In the table of grid squares shown above the "VUCC Award Progress Filter" panel, double-clicking the W or R in a grid square's row and the 6m column will filter the Log Page Display to show all 6m QSOs with that grid square.
73,
Dave, AA6YQ
