Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Reports, your help please...
14-04-2019, 11:22 PM, (This post was last modified: 14-04-2019, 11:33 PM by ct1bxx.)
#1
Reports, your help please...
Dear Colleagues,
I would like to ask your help…

I would like to learn a bit about the language to make reports, Could you please inform about books or website? 

And now I am looking for help to a given report:


I am creating a report for QTH Locator, but I only want to have the first 4 digits (ie IN51ra I only want to have IN51)

Could you please help?

Many thanks

73 Manuel Fernando

Here is my Report:

 SELECT QSO.L_DATE AS [Date],
         QSO.[Band] AS [Band],
         QSO.Mode,
         QSO.P_DXCC AS DXCC,
         QSO.L_QSL_RECEIVED AS QSLR,
         QSO.L_Call AS Call,
         QSO.MY_CALL,
         QSO.L_LOTW_RECEIVED AS LOTW_RECEIVED,
         QSO.P_QTHLOCATOR AS QTHLocator,
         QSO.L_eQSL_RECEIVED AS eQSL_RECEIVED
    FROM (QSO
         LEFT OUTER JOIN INF_DXCC
                      ON QSO.P_DXCC = INF_DXCC.DXCC)
         LEFT OUTER JOIN BANDS
                      ON QSO.L_BANDID = BANDS.BANDID
   WHERE (((QSO.Mode IN('FT8', 'PSK31', 'RTTY'))
     AND (QSO.L_QSONR in (SELECT       FIRST(L_QSONR)
    FROM Logbook,PQTH
   WHERE (L_QTHID = P_QTHID and (L_QSL_RECEIVED = 1 or L_LOTW_RECEIVED = 1))
GROUP BY  P_QTHLOCATOR))
     AND (QSO.P_QTHLOCATOR IS NOT NULL)))
ORDER BY QSO.P_QTHLOCATOR ASC
Reply
15-04-2019, 08:33 AM,
#2
RE: Reports, your help please...
Hello Manuel,

You don't need to know SQL language to create or modify reports. Read the inherent help of the report generator (press F1). If you want to display the QTH locator field with 4 digits, double click in the QTH locator field in the QUERY tab and set the Format field as 0000 (4 zeros) in the Value tab (Display section). This will force to display this field with 4 digits.

Best 73
Jordi, EA3GCV
Current developer of Swisslog
Reply
15-04-2019, 11:54 AM,
#3
RE: Reports, your help please...
Hello Jordi,

Many thanks for your help.

In fact yesterday I have read the help (Shazam Power Query) for this purpose but not found the solution I need.

The fomat works fine, however it is not the solution I am looking for, I only need one (4digit) QTHLocator. 

If I have a qth Locators like :
JO21BD
JO21PC
JO21RJ
JO21WT

I want only one JO21 and what I got is 4 - JO21 while I only want one JO21 the first or the last no matter. I have tried to use Show First but I got error.

Sorry to take your time.
Have a nice week.
73 Manuel Fernando ct1bxx
Reply
16-04-2019, 01:05 AM,
#4
RE: Reports, your help please...
Hello Manuel,

Please send me your report to my mail and I will check. The format is only for displaying not for handling data. Send me your report and I will try to find a solution.

Best 73
Jordi, EA3GCV
Current developer of Swisslog
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)