Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ReportPublishers
Product: Report Scheduler (3278)
Series:
Display Name: Report Publishers
Physical Name: ReportPublishers
Technical Name: ReportPublishersSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 USERID User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Report Publishers'].USERID AS 'Report Publishers-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
ReportPublishers AS ['Report Publishers']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Report Publishers'].USERID = ['Users Master'].USERID
2 PRODID Product ID Integer INT4 4 3 RPTGRIND Report Group Index Integer INT 0 4 Business_Desk_Report_Nam Business Desk Report Name String STR50 50 5 Report_Option Report Option String STR50 50