Hi,

I am trying to apply FULL OUTER JOIN in two synonyms using Reporting Server Console in 8.1 with parent child relation. getting following error after selecting FULL_OUTER join while click the test join option

(FOC32682) FULL/RIGHT JOIN IS SUPPORTED ONLY FOR SHORTPATH=SQL.

I know how to use SHORTPATH=SQL in code(in appstudio text editor) but not sure how to select SHORTPATH=SQL option in Reporting Server Console where we can create metadata in GUI mode.Please let me know if anyone have idea. Thanks in Advance.

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

I haven't tried this, but I think you can add SET SHORTPATH=SQL to edasprof.prf then generate the synonyms, then remove the SHORTPATH command from edasprof.prf. If this works, I'm not sure what it adds to the the acx or mas files.

If you try this and if it does work, please let us know.

Hi Francis,

its working fine after adding SHORTPATH=SQL entry in edasprof.prf.Thank You!

Did you find anything interesting in the acx and/or mas regarding SHORTPATH?