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

Notification

Icon
Error

Awards Report additional details
K8ZM
#1 Posted : Thursday, December 31, 2020 12:37:05 PM(UTC)
bwilliams

Rank: Advanced Member

Groups: Registered
Posts: 524
Location: Mentor, OH

Thanks: 123 times
Was thanked: 185 time(s) in 166 post(s)
Hi Dennis,

I run a bunch of reports and mostly use AWARDS and wonder if any of the following are possible:

1) When I run all the variants I have to close out after each one then re-launch the report again, is there anyway to have LOGic take you back to the beginning of the report so you can re-select the award and subsequent parameters, kind of like asking "do you want to run another report ?"
2) Is there anyway to add in the report header parameters like the band and mode selected for the award, i.e., If I run a GRID Awards Progress report, line 1 of the header says GRID Awards Progress Report for N8GLS, line 2 says Sub-Award: VUCC and Report Order, can I add a tag to read the band and mode I selected, example below highlighted red;

GRID Awards Progress Report for N8GLS
Sub-Award: VUCC Report Order: AWARD VALUE
Band: 2m Mode: Phone

Or, more simply, can one tag any of the parameters you have to select before running the report to print in the report.

Happy New Year !!

Brad, N8GLS
Sponsor
Note: We receive a commission from Amazon when you purchase via this link. It does not affect your cost. Thank you!
K8ZM
#2 Posted : Sunday, January 29, 2023 11:15:24 AM(UTC)
bwilliams

Rank: Advanced Member

Groups: Registered
Posts: 524
Location: Mentor, OH

Thanks: 123 times
Was thanked: 185 time(s) in 166 post(s)
This may have been lost in the ether so am re-posting with a couple edits;

I run a bunch of reports, mostly AWARDS and wonder if any of the following are possible:

1) When I run all the variants I have to close out after each one then re-launch the report again to change parameters, can it take you back to the beginning of the report so you can re-select the award and subsequent parameters, like asking "do you want to run another report ?"
2) Is there a way to add in the report header the band and mode selected, i.e., If I run a GRID Awards Progress report, header line 1 is GRID Awards Progress Report for K8ZM, line 2 is Sub-Award: VUCC and Report Order, can I add a tag for a new line 3 for Band and Mode selected, example below;

GRID Awards Progress Report for K8ZM
Sub-Award: VUCC Report Order: AWARD VALUE
Band: 2m Mode: Phone

73, Brad K8ZM
1 user thanked K8ZM for this useful post.
WN4AZY on 1/30/2023(UTC)
WN4AZY
#3 Posted : Monday, January 30, 2023 11:27:21 PM(UTC)
admin

Rank: Administration

Groups: Administrators, Beta Testers
Posts: 3,096
Man
Location: Auburn, GA

Thanks: 997 times
Was thanked: 497 time(s) in 412 post(s)
Thanks for reposting. I don't recall seeing it. Will study it tomorrow.
WN4AZY
#4 Posted : Monday, February 6, 2023 11:20:09 AM(UTC)
admin

Rank: Administration

Groups: Administrators, Beta Testers
Posts: 3,096
Man
Location: Auburn, GA

Thanks: 997 times
Was thanked: 497 time(s) in 412 post(s)
Addressing just #2 for now. No problem!

The expression is

sel_band + sel_mode

See attached.
WN4AZY
#5 Posted : Monday, February 6, 2023 11:21:37 AM(UTC)
admin

Rank: Administration

Groups: Administrators, Beta Testers
Posts: 3,096
Man
Location: Auburn, GA

Thanks: 997 times
Was thanked: 497 time(s) in 412 post(s)
I will address #2 only in this post.

No problem!

The expression is

sel_band + sel_mode

Following is more documentation that never got published: Look under GLOBAL VARIABLES for other stuff you can print.

Will get back to you on #1.

Tnx & 73,

Dennis WN4AZY

Lparameters report_type, cDfltAward, future1, future2, OptParm5

* Extracts log data for various awards reports.

* REPORT_TYPE:
* AWARDS Normal awards report. Selects best QSL status for each entity
*
* 1010 1010 and similar reports. Selects first QSL with an entity and assigns sequence number
*
* NEEDED Needed cards. Selects all QSOs with unconfirmed entities
*
* RAGCHEW For FISTS. Select 1 QSO per day per station that is >= 30 minutes in length.
* Allow selection by sequence# as per 1010. Pass OptParm5, which is min QSO
* length in minutes

* Output is to a cursor named PROGRESS. It contains all needed log fields, plus a
* record number (rec_no) indicating the record's number in the log file, making it
* easy to link back to log file. PROGRESS has these fields that are different than or in
* addition to the log file:
*
* VALUE Award value. Right-justified if numeric
* QSL_RCVD Extra codes: S=Submitted, U=Unworked, W=Worked
* OTHER Data for optional column from OTHERFIELD
* RECNO Recno() from log file
* DESCR Description from lists table
* DELETED Deleted status from lists table


* GLOBAL VARIABLES are created and may be used in report (created by awards_report form)
*
* award field name
* print_unworked
* subaward_expr expression used to select QSOs matching a sub-award
* submitted_tag tag marking submitted cards
* sel_band mode to print, blank for mixed
* sel_mode band to print, blank for mixed
* otherfield name of other field to print. Data is in field OTHER
* initial_select initial select criteria
* starting_number for 1010
* number_to_print for 1010
* accept_lotw .T. if LOTW counts for this award
* accept_eqsl
* prefer_paper_lotw set to "PAPER" or "LOTW"
File Attachment(s):
Screenshot 2023-02-06 111902.png (22kb) downloaded 25 time(s).
Screenshot 2023-02-06 111946.png (51kb) downloaded 25 time(s).
1 user thanked WN4AZY for this useful post.
K8ZM on 2/6/2023(UTC)
K8ZM
#6 Posted : Monday, February 6, 2023 1:40:58 PM(UTC)
bwilliams

Rank: Advanced Member

Groups: Registered
Posts: 524
Location: Mentor, OH

Thanks: 123 times
Was thanked: 185 time(s) in 166 post(s)
Perfect !! That works great !!

No hurry on #1, its not a show stopper by any means.

Brad, K8ZM

PS: Thanks for the additional "unpublished" tidbits...
1 user thanked K8ZM for this useful post.
WN4AZY on 2/7/2023(UTC)
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.051 seconds.