logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Awards reports - Adding a new "total count" field
IK0CHU
#1 Posted : Friday, February 14, 2014 12:42:20 PM(UTC)
RedBaron

Rank: Advanced Member

Groups: Registered
Posts: 360
Man
Location: Viterbo, VT - ITALY

Thanks: 56 times
Was thanked: 81 time(s) in 75 post(s)

Hello to All,
I would like to add the count of the total values included in each award.
For example, the report for the dxcc, tells me how much entities has been contacted and also confirmed but it lacks the total count of 340 countries.
Similarly for all award; for the RDA, for the U.S. county etc..
Can someone tell me what is the correct statement to be included in the printing report to get the total sum as in the AWARDCNT?
Thanks and 73's
IKØCHU Mauro
***
IKØCHU Mauro
Sponsor
Note: We receive a commission from Amazon when you purchase via this link. It does not affect your cost. Thank you!
vk4iu
#2 Posted : Friday, February 14, 2014 6:28:42 PM(UTC)
VK4IU

Rank: Advanced Member

Groups: Moderator, Registered, Administrators
Posts: 404
Man
Location: Hodgleigh QLD

Thanks: 6 times
Was thanked: 77 time(s) in 68 post(s)
G'Day Mauro,

There is no "expression" or "statement" that will print the total you want.

Let me explain why.

AWARDCNT reads the LISTS database - each separate list is usually an award. AWARDCNT simply counts the records for each list in the Lists database. The report sees all the records in the database and can print a total for each award and the database. AWARDCNT does not look at your QSOs.

For which report, or reports, do you want a total printed?

The AWARD reports are special - different from LOG/QSLING/CONTEST reports. Most of the award reports process your log of QSOs using a special function programmed in LOGic to extract all the relevant QSOs from your log into a new database. It is not possible for us to alter the special function.

The special function in LOGic "filters" the records to be printed from your log of QSOs. This subset of your QSOs is then passed to the report for printing. You can see this temporary set of records in c:\progress.xls and c:\progress.txt after you process a report.

As the records from c:\progress.xls are processed, one at a time, variables in the report can count each record as it is printed, count each group of records within all the records. A "total" is simply the total of the filtered records from your log - which may or may not be the total possible for the award. The "total" depends on your setting for this dialogue ...

total for award

... and the setting for the "filter" for the report. If you check this item a "dummy QSO" is added into the set of records in c:\progress.cls. If you change the values in QSL_RCVD $ "SFRWU" only QSOs matching this filter are passed to the report. The "total" will be different in each case.

I will have a look to see what may be possible if you indicate which report, or reports, for which you want the total printed?
Peter VK4IU
You can help by posting images of any errors and including your Logic version.
1 user thanked vk4iu for this useful post.
IK0CHU on 2/14/2014(UTC)
IK0CHU
#3 Posted : Friday, February 14, 2014 7:58:55 PM(UTC)
RedBaron

Rank: Advanced Member

Groups: Registered
Posts: 360
Man
Location: Viterbo, VT - ITALY

Thanks: 56 times
Was thanked: 81 time(s) in 75 post(s)

Hello Peter,
thanks for the detailed informations.
In fact, the problem could be solved so as you have suggested.
If the award report can not be changed because it related to the source of logic, there are no problems.
Thank you for your interest and active support in the resolution of the questions in the forum.
73's de IKØCHU Mauro
***
File Attachment(s):
ScreenShot292.jpg (281kb) downloaded 21 time(s).
IKØCHU Mauro
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF 1.9.5.5 | YAF © 2003-2011, Yet Another Forum.NET
This page was generated in 0.025 seconds.