Report Builld Dynamics Datasource

LEFRANCOIS Frederic OBS/DD 25 Reputation points
2023-09-01T13:09:27.14+00:00

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

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,782 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. AniyaTang-MSFT 12,306 Reputation points Microsoft Vendor
    2023-09-04T01:46:38.12+00:00

    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

    0 comments No comments

  2. LEFRANCOIS Frederic OBS/DD 25 Reputation points
    2023-09-04T06:16:33.99+00:00

    Hi Aniya,

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

    Best regards

    Fred

    0 comments No comments

  3. AniyaTang-MSFT 12,306 Reputation points Microsoft Vendor
    2023-09-04T09:00:48.3233333+00:00

    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

    0 comments No comments