Report Builld Dynamics Datasource

Question

Hello,

I would like to create a ssrs report with Report builder. But in the connection type, I don't see Ftchxml or a connection type pour connect to Dynamics.

Could you help me please?

Best regards,

Frédéric

Answer 1

Hi @LEFRANCOIS Frederic OBS/DD

For data sources supported by SSRS, you can check this document: https://learn.microsoft.com/en-us/sql/reporting-services/report-data/data-sources-supported-by-reporting-services-ssrs?view=sql-server-ver16.

If you are going to use Dynamics Datasource, it may be more convenient to use SSDT. You can check this link: https://www.crmcrate.com/ssrs-report/build-a-ssrs-report-in-dynamics-crm-step-by-step-guide/.

Best regards,

Aniya

Answer 2

Hi Aniya,

Thank you for your response. But With Visual Studio, it works. My customer uses Report Builder.

Best regards

Fred

Answer 3

Hi @LEFRANCOIS Frederic OBS/DD

Reporting Services retrieves report data from data sources through an extensible, modular data layer that uses data processing extensions. To retrieve report data from a data source, you must select a data processing extension that supports the data source type, the version of the software running on the data source, and the data source platform (32-bit or 64-bit).

If you want to connect to other data sources, you need a custom data extension plug-in. You can check this link: https://learn.microsoft.com/en-us/sql/reporting-services/report-data/data-processing-extensions-and-net-framework-data-providers-ssrs?view=sql-server-ver16.

Best regards,

Aniya