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

Notification

Icon
Error

How do I access Prefix DIRECTION in reports?
vk4iu
#1 Posted : Monday, February 13, 2012 6:32:18 AM(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,

I am using Logic 9.0.34

I see from the Logic 9 Help that DIRECTION is no longer held in the PREFIX table, but calculated on the fly for the Info form.

As shown in the PREFIX_LOOKUP_DEMO report, I use "getprefixinfo(call, qso_date)" in the detail band "on entry" to report DIRECTION for the call prefix.

Unforunately, in Logic 9, this no longer works as the DIRECTION field no longer exists in the PREFIX table.

Is there a function I can call to calculate direction for a prefix "on the fly" in a LOG report?

Peter VK4IU
Peter VK4IU
You can help by posting images of any errors and including your Logic version.
Sponsor
Note: We receive a commission from Amazon when you purchase via this link. It does not affect your cost. Thank you!
WN4AZY
#2 Posted : Monday, February 13, 2012 2:02:34 PM(UTC)
admin

Rank: Administration

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

Thanks: 998 times
Was thanked: 497 time(s) in 412 post(s)
Hi Peter:

The DX & Direction is not a simple function call. It would probalby be possible to do in the report writer, but would be messy.

This is your custom report I presume?

Look at our GRAYLINE and BEAM HEADING CHART to see how to do it. It is in the Commands section, FILE OPEN. Here is a copy of the code:

Quote:
select *, cast(0 as integer) as dx, cast(0 as integer) as direction from prefix order by dxcc into cursor prefixcursor readwrite

scan
whereitis.setcoords(lat, lon)
replace dx with whereitis.dxmiles, direction with whereitis.bearing

endscan


Be sure to select NONE for the View tab. Otherwise the commands won't run.

FYI, WHEREITIS is an object in a global memory variable. LOGic uses it for all DX and Direction calculations from your QTH.

You report from a file named PREFIXCURSOR. But if the report is done properly (no reference to the main file) it should run correctly without additional changes.

Let me know if any questions.

Tnx for using LOGic.

73,

Dennis WN4AZY
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.021 seconds.