Query Based SSRS Report in D365 F&O

• *Datasets: Based on requirement you can add multiple data sets.

• *Design: Based on requirement you can add multiple data sets.

• Images: if required you can add image in the report

Right click on the dataset and add new data source.

After it just select a select data source type as query.

After it click on query and new window will open from there select Data set you need then after this all fields will open then select your required fields.

• Click on NEXT button and then select required fields.

• After that click on the OK button.
• Now check in your data set you will get all fields which you have selected.

Right Click on the design and click on Auto Design,

From Properties select Dataset and Style Template.

Deploy your report. By right clicking on the report.

Select the Object Type as SSRSReport. and Also select the Object and give labels.

After it just make your menu item as startup object. Then you can build and run your project to see the output.