I've created about a dozen custom SSRS reports and uploaded them into CRM 2013 with no problem. However, they were all fairly simple reports. I just uploaded a large dashboard report with six charts and several small tables that runs fine in BIDS, and it's bombing out in the CRM app. I increased the timeouts on the queries in the .rdl to a ridiculous 20 minutes to make sure it wasn't simply timing out.
I then tested it out on the SSRS report server itself, instead of within CRM. It generates without throwing an error out there, but doesn't display anything. Yet I can export a PDF and in the PDF everything looks perfect (despite not having actually displayed anything in the report manager after the report successfully runs).
In CRM I get the generic rsProcessingAborted. This is the detail from the execution log:
<AdditionalInfo>
<ProcessingEngine>2</ProcessingEngine>
<ScalabilityTime>
<Processing>0</Processing>
</ScalabilityTime>
<EstimatedMemoryUsageKB>
<Processing>0</Processing>
</EstimatedMemoryUsageKB>
<DataExtension>
<MSCRM>6</MSCRM>
</DataExtension>
<Connections>
<Connection>
<ConnectionOpenTime>35</ConnectionOpenTime>
<DataSets>
<DataSet>
<Name>LeadBase</Name>
<RowsRead>0</RowsRead>
<TotalTimeDataRetrieval>562</TotalTimeDataRetrieval>
<ExecuteReaderTime>302</ExecuteReaderTime>
</DataSet>
</DataSets>
</Connection>
<Connection>
<ConnectionOpenTime>48</ConnectionOpenTime>
<DataSets>
<DataSet>
<Name>AppointmentBase</Name>
<RowsRead>0</RowsRead>
<TotalTimeDataRetrieval>532</TotalTimeDataRetrieval>
<ExecuteReaderTime>272</ExecuteReaderTime>
</DataSet>
</DataSets>
</Connection>
<Connection>
<ConnectionOpenTime>84</ConnectionOpenTime>
<DataSets>
<DataSet>
<Name>ApptsPacing</Name>
<RowsRead>0</RowsRead>
<TotalTimeDataRetrieval>360</TotalTimeDataRetrieval>
<ExecuteReaderTime>103</ExecuteReaderTime>
</DataSet>
</DataSets>
</Connection>
<Connection>
<ConnectionOpenTime>53</ConnectionOpenTime>
<DataSets>
<DataSet>
<Name>ApprovedSales</Name>
<RowsRead>0</RowsRead>
<TotalTimeDataRetrieval>516</TotalTimeDataRetrieval>
<ExecuteReaderTime>256</ExecuteReaderTime>
</DataSet>
</DataSets>
</Connection>
<Connection>
<ConnectionOpenTime>52</ConnectionOpenTime>
<DataSets>
<DataSet>
<Name>RegCardBase</Name>
<RowsRead>0</RowsRead>
<TotalTimeDataRetrieval>454</TotalTimeDataRetrieval>
<ExecuteReaderTime>273</ExecuteReaderTime>
</DataSet>
</DataSets>
</Connection>
<Connection>
<ConnectionOpenTime>0</ConnectionOpenTime>
<DataSets>
<DataSet>
<Name>ApprovedSalesBase</Name>
<RowsRead>0</RowsRead>
<TotalTimeDataRetrieval>0</TotalTimeDataRetrieval>
<ExecuteReaderTime>0</ExecuteReaderTime>
</DataSet>
</DataSets>
</Connection>
<Connection>
<ConnectionOpenTime>239</ConnectionOpenTime>
<DataSets>
<DataSet>
<Name>LeadPacing</Name>
<RowsRead>0</RowsRead>
<TotalTimeDataRetrieval>380</TotalTimeDataRetrieval>
<ExecuteReaderTime>121</ExecuteReaderTime>
</DataSet>
</DataSets>
</Connection>
</Connections>
</AdditionalInfo>
*This post is locked for comments
I have the same question (0)
