I'm trying to create a report for the External Objects I have created using the Files Connect for SharePoint setup, however when I 'Enable Reports' on the External Object, it does not appear in either the list of reports, or the list of objects used to create a custom report type. I've tried it in both a Dev Org and a Trailhead Playground so I don't think it's a licencing issue. I can't find any data about Files Connect reporting only 'Connect' reporting using ODATA connections: is using a Files Connect data source as opposed to an ODATA source the issue? Is this soemthing that is supported?
답변 6개
Hi Ashwin,
Unfortunately I didn't find a proper solution. Been having no end of issues with Files Connect, so I've had to implement it at its most base level. If you need the data to be available and reportable on but don't need it to update as and when changes occur, I suggest setting up a daily Apex job to pull data into a Salesforce object, and report on that instead. If you do this, you might run into some issues with metadata not being fetched in the soql query, I haven't found a solution to that, but you can get around this by ensuring the filename contains as much data as possible (rather than using metadata) and splitting the filename in the Apex to retrieve the data you need.
Sorry I couldn't be of more help.
