web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / CRM 2015 , Create SSRS...
Microsoft Dynamics CRM (Archived)

CRM 2015 , Create SSRS Report without using FetchXML(I want to use SQL Views in CRM DB)

(0) ShareShare
ReportReport
Posted on by uhh 56


Hi

We have CRM 2015 On Prem, I want to create an SSRS Report and Deploy in CRM without using FetchXML.

I would then like to deploy this report in CRM.

I want to be able to use sql views in CRM Database, any help or tutotial reference please.

*This post is locked for comments

I have the same question (0)
  • Inogic Profile Picture
    Inogic 748 on at

    To create SSRS Report (SQL base, without using Fetch XML) and deploy report in Dynamics 365.

     

    In order to create reports without fetch xml you have to create your own custom reports from scratch.

    You must have the required development tools and appropriate privileges in CRM2015 to write and deploy report. To know more use this link.

     

    Once you have it, create the report project in Visual studio and add the new report.

    Add Data source for the report and provide connection details as shown in below screen shot:

     

    Connection string:  Data Source=[Your SQL Server];Initial Catalog=[Organization database of CRM205]

    1SSRS-Report.jpg

    Once data source is connected, add data set where you can use the SQL query to pull data from your SQL view.

    2SSRS-Report.jpg

    To deploy a report in Dynamics 365:

    Sign in to CRM2015 and then go to Sales > Reports.

    1. On the command bar, click on New.
    2. In the Report: New Report dialog box – Select Existing File in the Report Type list. Click on Browse and specify the location of the .rdl file in the File Location box.
    3. Enter appropriate data in the Details section of the Report: New Report dialog box.
    4. Click on Save and Close.

    You can test the report by selecting it from Available Reports list.

    Hope this helps.

    Thanks!

  • Inogic Profile Picture
    Inogic 748 on at

    Thanks for like.

    If this answered your question, please make sure to Mark this as an Answer.

    Thanks!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
JS-09031509-0 Profile Picture

JS-09031509-0 3

#2
AS-17030037-0 Profile Picture

AS-17030037-0 2

#2
Mark Eckert Profile Picture

Mark Eckert 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans