GuruGroup logo
Microsoft Dynamics 365 F&O Technical Guide

Customize Standard SSRS Report in Dynamics 365

Executive Summary & Key Architectural Takeaways
  • Non-Intrusive SSRS Customization: Extending standard document print layouts (Project Invoice Proposal) without overlayering.
  • Temporary Table Extension: Adding custom fields like ServiceDate to the report buffer table PSAProjInvoiceTmp.
  • Data Provider Interception: Implementing Chain of Command (CoC) on PSAProjInvoiceDP.initFromProjProposalItem.
  • SSRS Design Duplication: Creating custom precision designs in Visual Studio and restoring datasets to recognize new fields.
  • Print Management Routing: Binding the customized design into Print Management for seamless invoice generation.

Overview: Project Invoice Proposal Customization

In this blog, we will customize the standard SSRS document print “Project Invoice Proposal” by adding the custom field Service date to it, along with performing cosmetic adjustments on the report design.

Navigation: Project management and accounting > Projects > All projects

The screenshot below illustrates the default format of the report where we need to remove unwanted standard columns and add our custom Service date field:

Default Project Invoice Proposal Report Format
Figure 1: Standard Project Invoice Proposal report highlighting fields to modify.

“Extending SSRS reports via table extensions and Data Provider Chain of Command ensures your customizations remain 100% compliant with continuous Microsoft updates.”

— Muhammad Hammad, Dynamics 365 Technical Consultant

Step 1: Extend PSAProjInvoiceTmp Table

We will create an extension of the table PSAProjInvoiceTmp. This temporary table contains the dataset populated by the data provider and consumed by the SSRS report:

Extending PSAProjInvoiceTmp Table
Figure 2: Adding ServiceDate field to the PSAProjInvoiceTmp table extension.

Step 2: Duplicate SSRS Report & Refresh Datasource

Duplicate the standard PSAProjInvoice report into your custom extension model. In the report designer, right-click the dataset and select Restore to refresh the schema and expose the new ServiceDate field:

Restoring Report Datasource in Visual Studio
Figure 3: Restoring the dataset to recognize the extended table schema.

Step 3: Chain of Command on Data Provider (DP) Class

Create a Chain of Command (CoC) extension of the initFromProjProposalItem method in the PSAProjInvoiceDP class to populate the custom field:

[ExtensionOf(classStr(PSAProjInvoiceDP))]
internal final class MDPSAProjInvoiceDP_Extension
{
    protected void initFromProjProposalItem(PSAProjProposalItem _projProposalItem)
    {
        next initFromProjProposalItem(_projProposalItem);

        psaProjInvoiceTmp.ServiceDate = _projProposalItem.ServiceDate;
    }
}

Step 4: Customize SSRS Layout & Final Output

Open the custom SSRS report precision design. Drag the ServiceDate field into the table row and remove any unnecessary standard columns:

Customizing Report Precision Design
Figure 4: Adjusting table columns and layout in SQL Server Data Tools / Visual Studio.

Final Output: Build your solution, deploy the report to the SSRS server, and print a Project Invoice Proposal. The document reflects your custom column formatting and service dates:

Final Customized Invoice Proposal Report Output
Figure 5: Final customized Project Invoice Proposal report displaying the Service Date column.
Ready to Move Forward?

Turn Your Business Goals into Measurable Results

Partner with Guru Group to design, deliver, and scale secure technology solutions for your organization.