SSRS User Story-4: In student entity create attachments in notes with jpg or png related images. Create a SSRS report with Specific student name, DOB, Date of Admission, along with student photo. Which is attached in notes. This should be work for individual students.

 

Entities:

·         Student

·         Notes

Fields:

  Student

o   Student name

o   DOB

o   Date Of Admission

Adding TimeLine in to student entity:

Fetch xml for retrieving Notes record

 

 

 

Report Creation: Right click on ProjectàAddàNew item

Here enter the Report Name and click ok Add

 

Right click on the Data Sources

choose Type as Microsoft Dynamics 365 Fetch

Connection String: Enter your CRM URL and click on ok

Click on the Credentials

Enter User name and Password click on Ok

Then Data Source is created

Right click on the Data Source and choose Add Data Set  

 

Here <attribute name="documentbody"/>  not came from fetch xml, we nee to add

In the link entity need to pass enableprefiltering=”1” for filtering students.

Design:

In photo field click on right àInsertà Image

Right click on Image field and click on Image Properties:

 

Output on Visual studio:

Output in CRM:

Open the student report click on Run Reportàchoose SSRS Report Name

 

After clicking on the SSRS report then below output will come.