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,534

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

  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 103,829 Super User 2026 Season 2 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,534 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,534 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,534 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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the September Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 740 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 531 Super User 2026 Season 2

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 310 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans