Options to deploy SSRS reports in D365FO

Hi,

Please refer to my earlier post to view the report SSRSPrecisionDesign related classes, tables and menu Item.

https://community.dynamics.com/365/financeandoperations/b/daxology/posts/creating-a-simple-report-in-d365fo

Custom Tables: SampleTable and SampleTrans

In this post, we will see the various approaches to deploy SSRS reports in D365FO

Approach 1: Report Deployment Thru Visual Studio

• Custom SSRS report can be deployed through the Visual Studio project. Right click on the required report and click on option  "Deploy Reports"
• Launch the output window to see the status of deployment.

Approach 2: Reports Deployment in a given model thru Windows PowerShell script

• All SSRS reports within a given model can de deployed through Windows PowerShell script "DeployAllReportsToSsrs".
• This command is available in the Plugins folder underneath PackageLocalDirectory folder.In my case the path is C:\AOSService\PackagesLocalDirectory\Plugins\AxReportVmRoleStartupTask.
• Launch Windows PowerShell command as administrator and type in below command to deploy the reports in model "Daxology".
• Command:: ./DeployAllReportsToSsrs.ps1 -Module Daxology -PackageInstallLocation "C:\AosService\PackagesLocalDirectory"
  Report Deployment

Approach 3: Individual Report Deployment in a given model thru Windows PowerShell script

• Required SSRS report can also be deployed using "DeployAllReportsToSsrs" Windows PowerShell script. For demo purpose let us try to deploy SSRSPrecisionDesignReport in the model Daxology.
• Launch Windows PowerShell command as administrator.
• Command: ./DeployAllReportsToSsrs.ps1 -Module Daxology -ReportName SSRSPrecisionDesignReport.Report -PackageInstallLocation "C:\AosService\PackagesLocalDirectory"
   Report Deployment

Approach 4: Reports Deployment following some name pattern in a given model thru Windows PowerShell script

• SSRS reports following a common name pattern can also be deployed using "DeployAllReportsToSsrs" Windows PowerShell script.
• For demo purpose let us try to deploy all Cust prefix reports in model ApplicationSuite
• Launch Windows PowerShell command as administrator
• Command: ./DeployAllReportsToSsrs.ps1 -Module ApplicatoinSuite -ReportName Cust* -PackageInstallLocation "C:\AosService\PackagesLocalDirectory"
   Report Deployment

After deploying the report, please check the timestamp of the report to confirm the deployment in the Web Portal URL provided in Reporting Services Configuration Manager.

 Reporting Services Manager

Regards,

Chaitanya Golla