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

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;

To conclude, 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!

We hope you found this blog useful, and if you would like to discuss anything, you can reach out to us at transform@cloudfonts.com.