I have a report that looks at one .mas file. It pulls one field. I have another .mas file that i was to join to. They share a common field name that is auto-joined by AS. I changed the properties to inner join and single instance and created it above the report on the procedure view. I can still run the report successfully, however on the Object Inspector, i am not seeing that new table i joined so that i can pull a field into the report. when i try to add the column in the text editor, it errors with "column name not identified".

Below is my report in text editor, the join is there, but i cant reference the column in the WFX_SITE_ALIAS table. It doesnt show up in the Obj Ins.



JOIN
INNER WFX_JOB_SUMMARY.WFX_JOB_SUMMARY.SITE_BUID IN wfx_job_summary TO UNIQUE
WFX_SITE_ALIAS.WFX_SITE_ALIAS.SITE_BUID IN wfx_site_alias TAG J0 AS J0
END
-* File: IBFS:/PSG/WFC/Repository/PSG_Comcast_Custom_Reports/WFX/Report1.fex Created by WebFOCUS AppStudio
-DEFAULT &DIVISION=_FOC_NULL;
TABLE FILE WFX_SITE_SETTINGS
BY WFX_SITE_SETTINGS.WFX_SITE_SETTINGS.SITE_DESC AS 'SITE'
WHERE DIV_DESC EQ &DIVISION;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT XML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/enwarm.sty,
$
ENDSTYLE
END

This message has been edited. Last edited by: FP Mod Chuck,

BABAL18

You are joining wfx_job_summary to wfx_site_alias but your TABLE request is referencing wfx_site_settings, it should reference wfx_job_summary.

*shaking my head*... so you're saying it's user-error :-)

That solved it, Chuck.. thanks! [solved]

It happens sometimes... Glad I could help!