Reports, your help please... - Printable Version +- Swisslog's Forum (https://www.swisslogforwindows.com/forum) +-- Forum: Swisslog version 5.x (https://www.swisslogforwindows.com/forum/forumdisplay.php?fid=3) +--- Forum: General discussion (https://www.swisslogforwindows.com/forum/forumdisplay.php?fid=4) +--- Thread: Reports, your help please... (/showthread.php?tid=580) |
Reports, your help please... - ct1bxx - 14-04-2019 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 RE: Reports, your help please... - EA3GCV - 15-04-2019 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 RE: Reports, your help please... - ct1bxx - 15-04-2019 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 RE: Reports, your help please... - EA3GCV - 16-04-2019 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 |