Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2021 Release Wave 1Discover the latest updates and new features to Dynamics 365 planned April 2021 through September 2021.
Release overview guides and videos Release Plan | Preview 2021 Release Wave 1 Timeline
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
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.
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]
Once data source is connected, add data set where you can use the SQL query to pull data from your SQL view.
To deploy a report in Dynamics 365: Sign in to CRM2015 and then go to Sales > Reports.
You can test the report by selecting it from Available Reports list.
Hope this helps.
Thanks for like.
If this answered your question, please make sure to Mark this as an Answer.
Business Applications communities