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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Company Information Ta...
Small and medium business | Business Central, N...
Answered

Company Information Table's Name "Field"

(0) ShareShare
ReportReport
Posted on by john.ellis 3,530

Hi:

In SSRS Report Builder, I'm modifying the Business Central Purchase Order (Report ID 10122).

I need to know the field in the Company Information table that houses the name of the company in Business Central.

I tried the following but found that it is not the field: Fields!CompanyAddress1.Value.

I have reviewed the Company Information table by typing "8700" in the Search (Tell Me) window, as well as by using "/?Table=79" at the end of the URL.  Still, I'm lost.

What field can I use in Report Builder to pull the company name?

Thanks!

John

I have the same question (0)
  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 101,126 Super User 2026 Season 1 on at

    Hi, If you cannot find the company name in the rdlc file, it means that the company name is not included in the AL file of the report, and you need to use ReportExtension to add it.

    https://yzhums.com/10723/

    Hope this will help.

    Thanks.

    ZHU

  • john.ellis Profile Picture
    john.ellis 3,530 on at

    Hi:

    In AL, should I somehow link the Company Information table to the Purchase Order Header table in order to add the "Company Information Name" field?

    John

  • Suggested answer
    Akshay_Panchal Profile Picture
    Akshay_Panchal 402 on at

    Hii,

    You have to add field on report through the report extension.

    Thanks.

    Verify, if this answer helpful to you

  • john.ellis Profile Picture
    john.ellis 3,530 on at

    But, don't I have to do that through table linking in AL?  Otherwise, how is it accomplished?

  • Suggested answer
    Akshay_Panchal Profile Picture
    Akshay_Panchal 402 on at

    Hii,

    You have to get the company information using the

    CompanyInfo.Get().

    right this code into the OnPreReport() trigger of report.

    Thanks.

    Verify, if this answer helpful to you

  • john.ellis Profile Picture
    john.ellis 3,530 on at

    How do I do that?

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,138 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,279 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,192

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans