web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Displaying company logo in an rdlc report

(5) ShareShare
ReportReport
Posted on by 70
Hi guys,
 
I saw a similar thread, but the suggested answers did not work. I am trying to show the company logo in an rdlc report but nothing seems to be working. I implemented CalcFields for the Blob field, that did not help. Set up properties in the rdlc layout and that did not help either. Maybe the format of the uploaded picture makes a difference, but I tried with png and bmp and it did not fix it either. Has anyone faced a similar problem recently?
I have the same question (0)
  • Suggested answer
    Jainam M. Kothari Profile Picture
    15,639 Super User 2025 Season 2 on at
    Hello,
     
    i don't have much technical knowledge but You can get the Company Logo from Company Information.
     
    And Even in Sales & Receivable Setup there is a Place where you want to Upload the Company Logo.
  • LK-07050844-0 Profile Picture
    70 on at
    that is the table that I am using in my report
  • Suggested answer
    Jainam M. Kothari Profile Picture
    15,639 Super User 2025 Season 2 on at
    Ok. Sounds Good.
     
    Now Which field you can use that may help by another technical person.
     
    Thank you.
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    20,647 Super User 2025 Season 2 on at
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    20,647 Super User 2025 Season 2 on at
    Share your code will check it.
  • LK-07050844-0 Profile Picture
    70 on at
    this is the code as it stands atm. I will share the specific data item since I can't share the other things, and the related triggers. Note: Even the triggers that you will see empty, I have already tested out some code within them, just left them empty since nothing worked. If you have any suggestions for changes within the layout, feel free to share them!
     
     
            dataitem("Company Information"; "Company Information")
            {
                column(Company_Name; Name)
                {
                    IncludeCaption = true;
                }
                column(AddressCompany; Address)
                {
                    IncludeCaption = true;
                }
                column(City; City)
                {
                    IncludeCaption = true;
                }
                column(VAT_Registration_No_; "VAT Registration No.")
                {
                    IncludeCaption = true;
                }
                column(VAT_Registration_NoCaption; VAT_Registration_NoCaptionLbl)
                {
                }
                column(Bank_Account_No_; "Bank Account No.")
                {
                    IncludeCaption = true;
                }
                column(Bank_Account_NumberCaption; Bank_Account_NumberCaptionLbl)
                {
                }
                column(Picture; Picture)
                {
                    IncludeCaption = true;
                }
                column(Phone_No_; "Phone No.")
                {
                    IncludeCaption = true;
                }
                column(EMailComp; "E-Mail")
                {
                    IncludeCaption = true;
                }
                trigger OnPreDataItem()
                begin
     
                end;
     
                trigger OnAfterGetRecord()
                begin
     
                end;
            }
     
        }
     
        trigger OnPreReport()
        begin
            CompanyInfo.Reset();
            CompanyInfo.get();
            CompanyInfo.CalcFields(Picture);
        end;
     
        trigger OnInitReport()
        var
        // myInt: Integer;
        begin
            CompanyInfo.SetAutoCalcFields(Picture);
            CompanyInfo.Get();
        end;
     
        var
            CompanyInfo: Record "Company Information";
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    20,647 Super User 2025 Season 2 on at
    Hi,
     

     
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    20,647 Super User 2025 Season 2 on at
    Code: 
     
    report 50147 MyReport
    {
        UsageCategory = ReportsAndAnalysis;
        ApplicationArea = All;
        DefaultRenderingLayout = LayoutName;
     
        dataset
        {
            dataitem("Company Information"; "Company Information")
            {
                column(Company_Name; Name)
                {
                    IncludeCaption = true;
                }
                column(AddressCompany; Address)
                {
                    IncludeCaption = true;
                }
                column(City; City)
                {
                    IncludeCaption = true;
                }
                column(VAT_Registration_No_; "VAT Registration No.")
                {
                    IncludeCaption = true;
                }
                // column(VAT_Registration_NoCaption; VAT_Registration_NoCaptionLbl)
                // {
                // }
                column(Bank_Account_No_; "Bank Account No.")
                {
                    IncludeCaption = true;
                }
                // column(Bank_Account_NumberCaption; Bank_Account_NumberCaptionLbl)
                // {
                // }
                column(Picture; Picture)
                {
                    IncludeCaption = true;
                }
                column(Phone_No_; "Phone No.")
                {
                    IncludeCaption = true;
                }
                column(EMailComp; "E-Mail")
                {
                    IncludeCaption = true;
                }
                trigger OnPreDataItem()
                begin
     
                end;
     
                trigger OnAfterGetRecord()
                begin
     
                end;
            }
     
        }
     
        rendering
        {
            layout(LayoutName)
            {
                Type = rdlc;
                LayoutFile = 'mySpreadsheet.rdl';
            }
        }
     
        // trigger OnPreReport()
        // begin
        //     CompanyInfo.Reset();
        //     CompanyInfo.get();
        //     CompanyInfo.CalcFields(Picture);
        // end;
        trigger OnInitReport()
        begin
            "Company Information".Get();
            "Company Information".SetAutoCalcFields(Picture);
        end;
        // trigger OnInitReport()
        // var
        // begin
        //     CompanyInfo.SetAutoCalcFields(Picture);
        //     CompanyInfo.Get();
        // end;
     
        // var
        //     CompanyInfo: Record "Company Information";
    }
     
    rdl:
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,066

#2
YUN ZHU Profile Picture

YUN ZHU 658 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 595

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans