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

Notifications

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

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 95,329 Super User 2025 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,510 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,510 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,510 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

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,229

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,867 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,153 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans