How to create a SSRS Report using Visual Studio and Fetch XML for Dynamics 365
In this post I will explain how to create a SSRS Report for Dynamics 365 Application. For this post we need to have SQL Data Tools 2015 (Choose the correct version of visual studio) and Report Authoring Extension package.
If you want to watch the video then watch the below video where I have explained the details steps otherwise scroll down to read the article.
Step:1 – Install Visual Studio, SQL Data Tools and Reporting Author Extension package.
For this post we need to have SQL Data Tools 2015 (Choose the correct version of visual studio) and Report Authoring Extension package.
Step:2 – Create a SQL Server Data Tool and Select Report Server Project.
You need to create a Report Server Project. Provide a name of project, location and click OK.
Step:3 – Follow the Wizard and provide connection string as below screenshot
Use correct way of connection string as given below
Now provide the fetchxml in the query builder window.
Once click Next select the Visualization as Tabular.
Design the table as below. Choose the Columns
Press Next. Now the table will look like below
Now when you run the report it will render and we can deploy the report .RDL file to dynamics. Watch the video for more clarity.
Don’t miss the chance to participate in the upcoming Internship Program which will be done using Microsoft Dot Net Web Development Full Stack Technology. The new batch will be starting from May 20, 2024. We will have most experienced trainers for you to successfully complete the internship with live project experience.
Why to choose Our Internship Program?
Industry-Relevant Projects
Tailored Assignments: We offer projects that align with your academic background and career aspirations.
Real-World Challenges: Tackle industry-specific problems and contribute to meaningful projects that make a difference.
Professional Mentorship
Guidance from Experts: Benefit from one-on-one mentorship from seasoned professionals in your field.
Career Development Workshops: Participate in workshops that focus on resume building, interview skills, and career planning.
Networking Opportunities
Connect with Industry Leaders: Build relationships with professionals and expand your professional network.
Peer Interaction: Collaborate with fellow interns and exchange ideas, fostering a supportive and collaborative environment.
Skill Enhancement
Hands-On Experience: Gain practical skills and learn new technologies through project-based learning.
Soft Skills Development: Enhance communication, teamwork, and problem-solving skills essential for career success.
Free Demo Class Available
