CRM Online new report

(0) Share

Report

Posted on by Tom E

145

Hi,

I've been asked to produce a new report for use in CRM Online.

The brief is they want the report to show all opportunities which are open and along with this then show any activities tied to these opportunities which are also open but it needs to display opportunities which have no activities as well which would require an outer join.

From the reading I've done outer joins are not possible within FetchXML so is there any way round this?

I'm a SSRS report developer so have a good understanding of the reporting itself and could do this no problem if it was through a SQL or ODBC datasource.

*This post is locked for comments