Why should I use SSRS report in Dynamics 365?

(0) Share

Report

Posted on by TomSD365

Hello,

As I understand, there are various possibilities of getting required details - I wonder how SSRS report stands out for D365 and why one should use it?

Thanks,

All responses (2)

Answers (1)

Verified answer

Leah Ju Microsoft Employee on at

Like (1)

Report
RE: Why should I use SSRS report in Dynamics 365?

HI TomSD365,

SQL Server Reporting Services (SSRS) reports allow pixel perfect paginated reports to be created that can be rendered on screen and distributed in a range of ways such as PDF, CSV, Excel, and so on.

You can refer to the following to know benefits of SSRS for reporting:

Very flexible on how the report is formatted

Can display in a common tabular or matrix format

Can add images

Can add headers and footers

Can display multiple child tables (with the help of a sub report)

Can add prompts (e.g. a date range, a team/user) to help end users running the report to filter the data

Can add/remove sorting features

Can adjust the width so that it is formatted properly for your export format of choice (Word, PDF, Excel, etc)

Can import to Dynamics 365 which will then behave similar to one that was developed using the Dynamics 365 report wizard tool:

Can easily configure them to run from a single record or multiple

Security is based on the Dynamics 365 users security role(s)

Unable to schedule them on a recurring basis out of the box in Dynamics 365 online

https://go.christiansteven.com/ssrs/sql-reporting-services-ssrs-design-generate-deploy-business-reports
Pawan Upadhyay 60 on at

Like (1)

Report

RE: Why should I use SSRS report in Dynamics 365?

Hello,

The question is more about what is the use case, what will be the data you are going to use to create report.

Option 1 : If the data is inside D365 F&O than go with SSRS reports.

Option 2 : If the data required for report is out side D365 F&O , means you want to create a report using data from D365 F&O and other third party applications or some other application from D365 family than better to collect data at one place like Azure SQL or azure data lake and use reporting tool like Power BI to create report out of it.

Thanks