Elevating SSRS Reports with Dynamics Company Logo in D365 F&O

Introduction:

In the world of corporate reporting, presentation matters just as much as data. The more personalized and professional your reports look, the more impactful they become. If you’re using Dynamics 365 Finance and Operations (F&O), chances are you rely on SSRS (SQL Server Reporting Services) reports to generate vital business insights. But, have you ever wondered how to make those reports more aligned with your company’s branding? Are you struggling with adding your company logo to SSRS reports in F&O?

I am going to show you how to easily embed your corporate logo into your SSRS reports within Dynamics 365 F&O, transforming your data into visually appealing reports that reflect your brand identity. Whether you're preparing financial statements, customer invoices, or custom reports, adding a logo enhances the look and feel, ensuring that your reports maintain a consistent and professional corporate image.


Steps to Achieve the goal

Before embedding your logo into the SSRS report, ensure that the image file (usually in PNG, JPG, or GIF format) is prepared and accessible. You need to upload the logo to a location within the F&O environment where your SSRS report can access it. Follow these steps:

  • Navigate to Organization Administration: Go to Organization Administration > Organizations > Legal Entities.
  • Select the Report Company Logo Image Tab: Under the Legal Entities section, locate and select the Report Company Logo Image tab.
  • Upload the Logo: Choose and upload the logo you wish to use to the tab.
  • Now, to embed the logo in the SSRS report:
  • If the report is customized, find the temporary table created for SSRS and add a field named CompanyLogo with the data type Container.
  • Set the extended data type (EDT) as BITMAP as shown in the screenshot.

  • Next, navigate to the report object type, then click on the dataset. Select the dataset you created, and click on "Restore" to add the new field to the report table.


  • Next, open the report designer and add a page header to the report. Insert an image box and open its properties. Set the Image Source to Database and the MIME Type to BMP. Then, select the field from which the logo will be sourced.
  • In this case, the field will be CompanyLogo.
  • Use the following expression to set the dataset field value:
  • =First(Fields!CompanyLogo.Value, "CF_SalarySlip")

  • Now we have to also add some logic to fetch company logo from F&O  in our DP class 
  • Create a variable for company logo 
  • CompanyInfo companyInfo = CompanyInfo::find();
  • Now where all values are set in your TMP table in there add the below line of code
  • CFS_SalarySlip.CompanyLogo = CompanyImage::findByRecord(companyInfo).Image;


Conclusion:
Adding your company logo to your SSRS reports in Dynamics 365 Finance & Operations is a powerful way to enhance your brand’s presence across all reports.You can instantly elevate the look and feel of your documents.
Happy Coding!




Comments

Post a Comment

Popular posts from this blog

Restoring a Deleted Posted Bank Reconciliation in Business Central: A Comprehensive Guide

Introduction: Are you struggling with restoring a deleted posted bank reconciliation in Business Central? In this blog, I’m going to guide you through the process of effectively restoring a deleted posted bank reconciliation and ensuring the accuracy of your financial records. You’ll learn the step-by-step procedure to re-post a deleted bank reconciliation, along with best practices to prevent future errors and maintain the integrity of your financial data. Let’s get started! Steps to Achieve Goal: Create a New Editable Bank Ledger Entry Page: Use AL code to create a new page, ensuring it allows for editing the Bank Ledger Entry. The code should expose fields such as Statement No, Statement Line No, and Statement Status so they can be modified. Here’s an example of how to create a simple editable page in AL page 50100 BankLedgerEntryEditable {     ApplicationArea = All;     Caption = 'Bank Ledger Entry Editable';     PageType = List;     SourceTa...
Read more

Seamless Integration: How to Sync Business Central with External Systems Instantly or in Batches

Introduction: In today's fast-paced business world, integrating your ERP system (like Business Central) with other external systems is crucial for streamlining processes and ensuring data consistency. However, if you're new to API integrations or struggling with how to send data from Business Central to another system, don't worry! In this post, I am going to walk you through the process of sending data from Business Central to an external system using APIs. By the end of this guide, you'll have a clear understanding of how to perform integrations smoothly, without the complexity. Steps to Achieve Goal: You can easily send data from Business Central to an external system by calling the link set in General Ledger Setup. Below is the logic for sending data via an API. You can encapsulate this logic inside a Codeunit, and call it as needed based on your synchronization requirements: Real-Time Data Sync: If you want the data to be synced in real-time (for example, as soon ...
Read more
Image
  Agent Payables Configuration in Business Central Introduction Accounts Payable (AP) is often one of the most repetitive and error-prone areas in finance. With the Payables Agent in Microsoft Dynamics 365 Business Central (2025 Wave 1), companies can now automate much of this process. Instead of clerks manually entering invoice details, the agent uses AI to capture, draft, and suggest invoice data—freeing finance teams to focus on strategic tasks. Steps to Achieve Agent Payables Configuration             On the top right corner of Business Central, click the AP (Accounts Payable) icon Activate the Agent Connect the mailbox where you wish to get all your invoice in pdf form. The agent will monitor this inbox, import PDFs, and archive them automatically The agent matches invoices with existing vendors. If no match is found, supervisors can approve the creation of a new vendor card. if the vendor exist you will get notificat...
Read more