CRM 2016, SQL2016
I'm trying and failing to create a simple report in SSRS and import it to CRM
IN SSRS the report renders fine, however when trying to upload it to CRM I get an error
Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: An error occurred while trying to add the report to Microsoft Dynamics 365. Try adding the report again. If this problem persists, contact your system administrator.Detail:
<OrganizationServiceFault xmlns:i="www.w3.org/.../XMLSchema-instance" xmlns="schemas.microsoft.com/.../Contracts">
<ActivityId>de8e3375-91c0-4659-9234-0f0bc363c1db</ActivityId>
<ErrorCode>-2147188072</ErrorCode>
<ErrorDetails xmlns:d2p1="schemas.datacontract.org/.../System.Collections.Generic" />
<Message>An error occurred while trying to add the report to Microsoft Dynamics 365. Try adding the report again. If this problem persists, contact your system administrator.</Message>
<Timestamp>2018-04-04T11:26:59.9916925Z</Timestamp>
<ExceptionRetriable>false</ExceptionRetriable>
<ExceptionSource i:nil="true" />
<InnerFault i:nil="true" />
<OriginalException i:nil="true" />
<TraceText i:nil="true" />
</OrganizationServiceFault>
my report query
SELECT Account.Name, Account.new_companyname, Account.Address2_Line1, Account.Address2_Line2, Account.Address2_Line3, Account.Address2_City, Account.Address2_StateOrProvince, Account.Address2_PostalCode,
Account.new_pono, CRMAF_FilteredInvoice.invoicenumber, CASE ISNULL(Account.new_paybydirectdebit, 0) WHEN 1 THEN 1 ELSE 0 END AS 'new_paybydirectdebit', CRMAF_FilteredInvoice.datedelivered,
CRMAF_FilteredInvoice.duedate, CRMAF_FilteredInvoice.new_invoicetype
FROM FilteredInvoice AS CRMAF_FilteredInvoice INNER JOIN
Account ON CRMAF_FilteredInvoice.accountid = Account.AccountId
