I have a report that has two SQL tables left joined with multiple &measures built in the report. When I run the report it is only returning the rows in the second table but the ones that are not in the second table but in the first one are not displaying. Why are the not displaying?

Thanks,

-DEFAULT &Measure1='EZG';
-SET &Measure1 = IF &Measure1 EQ 'EZG' THEN 'EZG' ELSE 'FOC_NONE';
-DEFAULT &Measure2='GTA_1';
-SET &Measure2 = IF &Measure2 EQ 'GTA_1' THEN 'GTA_1' ELSE 'FOC_NONE';
-DEFAULT &Measure3='GTA_PASSWORD';
-SET &Measure3 = IF &Measure3 EQ 'GTA_PASSWORD' THEN 'GTA_PASSWORD' ELSE 'FOC_NONE';
-DEFAULT &Measure4='TRAVEL_IMPRESSIONS';
-SET &Measure4 = IF &Measure4 EQ 'TRAVEL_IMPRESSIONS' THEN 'TRAVEL_IMPRESSIONS' ELSE 'FOC_NONE';
-DEFAULT &Measure5='TRAVETECH';
-SET &Measure5 = IF &Measure5 EQ 'TRAVETECH' THEN 'TRAVETECH' ELSE 'FOC_NONE';
-DEFAULT &Measure6='CSA';
-SET &Measure6 = IF &Measure6 EQ 'CSA' THEN 'CSA' ELSE 'FOC_NONE';
-DEFAULT &Measure7='RBC';
-SET &Measure7 = IF &Measure7 EQ 'RBC' THEN 'RBC' ELSE 'FOC_NONE';
-DEFAULT &Measure8='TravelGuard';
-SET &Measure8 = IF &Measure8 EQ 'TravelGuard' THEN 'TravelGuard' ELSE 'FOC_NONE';
-DEFAULT &Measure9='TRAVELINSURED';
-SET &Measure9 = IF &Measure9 EQ 'TRAVELINSURED' THEN 'TRAVELINSURED' ELSE 'FOC_NONE';
-DEFAULT &Measure10='Viking';
-SET &Measure10 = IF &Measure10 EQ 'Viking' THEN 'Viking' ELSE 'FOC_NONE';
JOIN
 LEFT_OUTER WEBFOCUS_REPORT_AGENCY_DATA.WEBFOCUS_REPORT_AGENCY_DATA.AGENCYID IN
WEBFOCUS_REPORT_AGENCY_DATA TO MULTIPLE
 WEBFOCUS_REPORT_EZGUIDER.WEBFOCUS_REPORT_EZGUIDER.AGENCY_ID_PK
 IN WEBFOCUS_REPORT_EZGUIDER AS J0
 END
DEFINE FILE WEBFOCUS_REPORT_AGENCY_DATA
AMDI/A512=
IF AMADEUSOFFICEID EQ MISSING THEN 'NULL' ELSE
AMADEUSOFFICEID;
AMDID/A20=IF AMDI EQ 'NULL' THEN 'N' ELSE 'Y';
PHONE2/A35=IF PHONE EQ '' THEN '' ELSE EDIT(PHONE, '(999) 999-9999');
FAX2/A35=IF FAX EQ '' THEN '' ELSE EDIT(FAX, '(999) 999-9999');
EZG/A512=
IF EZguider_CruiseSolution EQ '0' THEN 'NULL' ELSE
IF EZguider_CruiseSolution EQ MISSING THEN 'NULL' ELSE
IF EZguider_CruiseSolution EQ '' THEN 'NULL' ELSE
IF EZguider_CruiseSolution EQ 'NULL' THEN 'NULL' ELSE
EZguider_CruiseSolution;
Viking/A512V=
IF VIKING_CREDENTIALED EQ '0' THEN 'NULL' ELSE
IF VIKING_CREDENTIALED EQ MISSING THEN 'NULL' ELSE
IF VIKING_CREDENTIALED EQ 'NULL' THEN 'NULL' ELSE
IF VIKING_CREDENTIALED EQ '' THEN 'NULL' ELSE
IF VIKING_CREDENTIALED EQ '.' THEN 'NULL' ELSE
VIKING_CREDENTIALED;
Suite/A4='NULL';
CSA/A5=
IF CSA_CREDENTIALED EQ MISSING THEN 'NO' ELSE
IF CSA_CREDENTIALED EQ 'NULL' THEN 'NO' ELSE
IF CSA_CREDENTIALED EQ 'Yes' THEN 'YES' ELSE
IF CSA_CREDENTIALED EQ '1' THEN 'YES' ELSE
'NO';
RBC/A5=
IF RBC_CREDENTIALED EQ MISSING THEN 'NO' ELSE
IF RBC_CREDENTIALED EQ 'NULL' THEN 'NO' ELSE
IF RBC_CREDENTIALED EQ 'Yes' THEN 'YES' ELSE
IF RBC_CREDENTIALED EQ '1' THEN 'YES' ELSE
'NO';
TravelGuard/A5=
IF TRAVELGUARD_CREDENTIALED EQ MISSING THEN 'NO' ELSE
IF TRAVELGUARD_CREDENTIALED EQ 'NULL' THEN 'NO' ELSE
IF TRAVELGUARD_CREDENTIALED EQ 'Yes' THEN 'YES' ELSE
IF TRAVELGUARD_CREDENTIALED EQ '1' THEN 'YES' ELSE
'NO';
TRAVELINSURED/A5=
IF TRAVELINSURED_CREDENTIALED EQ MISSING THEN 'NO' ELSE
IF TRAVELINSURED_CREDENTIALED EQ 'NULL' THEN 'NO' ELSE
IF TRAVELINSURED_CREDENTIALED EQ 'Yes' THEN 'YES' ELSE
IF TRAVELINSURED_CREDENTIALED EQ '1' THEN 'YES' ELSE
'NO';
TRAVETECH/A516=
IF BRANCH_ID EQ MISSING THEN 'NULL' ELSE
BRANCH_ID;
TRAVEL_IMPRESSIONS/A516=
IF TRAVEL_IMPRESSIONS_ID EQ MISSING THEN 'NULL' ELSE
TRAVEL_IMPRESSIONS_ID;
GTA_PASSWORD/A516=
IF GTA_TRAVELBOUND_PASSWORD EQ MISSING THEN 'NULL' ELSE
GTA_TRAVELBOUND_PASSWORD;
GTA_1/A516=
IF GTA_CLIENTID EQ MISSING THEN 'NULL' ELSE
GTA_CLIENTID;
VIKINGFILTER/A5=
IF Viking EQ 'NULL' THEN 'N'
ELSE 'Y';
CSAFILTER/A5=IF CSA EQ 'YES' THEN 'Y' ELSE 'N';
RBCFILTER/A5=IF RBC EQ 'YES' THEN 'Y' ELSE 'N';
TRAVELGUARDFILTER/A5=IF TravelGuard EQ 'YES' THEN 'Y' ELSE 'N';
TRAVELINSUREDFILTER/A5=IF TRAVELINSURED EQ 'YES' THEN 'Y' ELSE 'N';
TRAVTECHFILTER/A5=
IF TRAVETECH EQ 'NULL' THEN 'N' ELSE
IF TRAVETECH EQ '0' THEN 'N' ELSE 'Y';
TRAVELIMPRESSIONSFILTER/A5=IF TRAVEL_IMPRESSIONS EQ 'NULL' THEN 'N' ELSE 'Y';
GTAPASSWORDFILTER/A5=IF GTA_PASSWORD EQ 'NULL' THEN 'N' ELSE 'Y';
GTAFILTER/A5=IF GTA_1 EQ 'NULL' THEN 'N' ELSE 'Y';
END
TABLE FILE WEBFOCUS_REPORT_AGENCY_DATA
SUM
     &Measure1
     &Measure2
     &Measure3
     &Measure4
     &Measure6
     &Measure7
     &Measure8
     &Measure9
     &Measure10
BY AGENCYID NOPRINT
BY AGENCYNAME
BY INDUSTRYID
BY AGENCYNAME
BY ADDRESS1
BY ADDRESS2
BY CITY
BY STATE
BY ZIPCODE
BY COUNTRY
BY PHONE
BY FAX
BY EMAIL
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=9,
$
TYPE=DATA,
     COLUMN=N2,
     JUSTIFY=CENTER,
$
TYPE=DATA,
     COLUMN=N3,
     JUSTIFY=CENTER,
$
TYPE=DATA,
     COLUMN=N8,
     JUSTIFY=CENTER,
$
TYPE=DATA,
     COLUMN=N9,
     JUSTIFY=CENTER,
$
TYPE=DATA,
     COLUMN=N11,
     JUSTIFY=CENTER,
$
TYPE=DATA,
     COLUMN=N12,
     JUSTIFY=CENTER,
$
TYPE=DATA,
     COLUMN=N1,
     JUSTIFY=CENTER,
$
TYPE=DATA,
     COLUMN=N4,
     JUSTIFY=CENTER,
$
TYPE=DATA,
     COLUMN=N5,
     JUSTIFY=CENTER,
$
TYPE=DATA,
     COLUMN=N6,
     JUSTIFY=CENTER,
$
TYPE=DATA,
     COLUMN=N7,
     JUSTIFY=CENTER,
$
TYPE=DATA,
     COLUMN=N10,
     JUSTIFY=CENTER,
$
TYPE=DATA,
     COLUMN=N13,
     JUSTIFY=CENTER,
$
TYPE=TITLE,
     STYLE=BOLD,
$
TYPE=TITLE,
     COLUMN=N2,
     JUSTIFY=CENTER,
$
TYPE=TITLE,
     COLUMN=N3,
     JUSTIFY=CENTER,
$
TYPE=TITLE,
     COLUMN=N8,
     JUSTIFY=CENTER,
$
TYPE=TITLE,
     COLUMN=N9,
     JUSTIFY=CENTER,
$
TYPE=TITLE,
     COLUMN=N11,
     JUSTIFY=CENTER,
$
TYPE=TITLE,
     COLUMN=N12,
     JUSTIFY=CENTER,
$
TYPE=TITLE,
     COLUMN=N1,
     JUSTIFY=CENTER,
$
TYPE=TITLE,
     COLUMN=N4,
     JUSTIFY=CENTER,
$
TYPE=TITLE,
     COLUMN=N5,
     JUSTIFY=CENTER,
$
TYPE=TITLE,
     COLUMN=N6,
     JUSTIFY=CENTER,
$
TYPE=TITLE,
     COLUMN=N7,
     JUSTIFY=CENTER,
$
TYPE=TITLE,
     COLUMN=N10,
     JUSTIFY=CENTER,
$
TYPE=TITLE,
     COLUMN=N13,
     JUSTIFY=CENTER,
$
TYPE=TABHEADING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=TABFOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=HEADING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=FOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=SUBHEAD,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBFOOT,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBTOTAL,
     BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
     SIZE=9,
$
TYPE=ACROSSTITLE,
     STYLE=BOLD,
$
TYPE=GRANDTOTAL,
     BACKCOLOR=RGB(210 210 210),
     STYLE=BOLD,
$
ENDSTYLE
END
  

This message has been edited. Last edited by: kfr104,

Turn on SQL traces to see the SQL generated by WebFOCUS. This will help in determining the solution to your problem. Perhaps the JOIN is not correct - if it isn't, you will get informational messages.

What code do I use to turn the trace on?

Thanks...

This is where a little searching in Focal Point will be very valuable to you. Search for sql trace, you'll find dozens of posts.