Dynamics365 - SQL Reporting working / FetchXML Reporting not working (rsProcessingAborted)

There are thousands of posts about the rsProcessingAborted error but most of them are pointing to general reporting (rdl) issues.

In the current project (ongoing for few years), we introduced the first FetchXML based report now. The previous ones have been SQL based (OnPrem).

After deploying the report from Test to QA, the following error code appeared.

The report cannot be displayed. (rsProcessingAborted)

Since SQL based reports were working fine it could not be a general reporting issue.
Also a newly created temp report with only one column was not working so also an error with the newly designed report could not be the reason.

After checking the SSRS logs (\Reporting Services\LogFiles), I could see following message.

Could not connect to net.tcp:///CrmSandboxSdkListener-w3wp.

After checking the Implementation Guide - "Dynamics365_PlanandDeploy.pdf", I found the following entry.

After opening the TCP 808 port, the rendering worked as expected.

cheers

Powerpoint Statusslides Hell (Traffic Lights) - Solved

The last years I was looking more or less every week on status slides or I had to create them. Whereever possible, I try to use direct exports from tools like TFS and just copy the table to the deck.

Sometimes a specific format for the famous traffic lights status column is required. So most people (including me until today) were just adding a circle shape and putting it into the Status-Column.

The week after, you need to add new items to the table and your format gets broken because the circles are just not moving.
To get rid of this issue, you can easily use Symbols in Powerpoint.

Insert --> Symbol --> Symbol --> Select the one you need --> just change Font-Size and Color

The symbol will now be handled like every other regular text.
Alternatively you can just copy and past the black dot from below.

⬤

Black Large Circle

Result:

Cheers,
Markus