Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

how to display company url through code in ssrs report.

Posted on by 5,901

Hi All,

Could you please let me know how I will display company url in packing slip report in header. I searched in legal entity, there is no field for company url.

Kindly let me know how to display company url through code in ssrs report.

Please give me more shed on this 

Thanks!

  • Suggested answer
    Fangyuan Hou Profile Picture
    Fangyuan Hou on at
    RE: how to display company url through code in ssrs report.

    Hi,

    Do you want use display methods in a Report? Please see the below docs.

    docs.microsoft.com/.../how-to-use-display-methods-in-a-report

    The return value is "LOCATOR" field on table LogisticsElectronicAddress.

    select LOCATOR,* from LOGISTICSELECTRONICADDRESS join DirPartyTable on DirPartyTable.PrimaryContactURL = LOGISTICSELECTRONICADDRESS.RECID

  • @rp@n Profile Picture
    @rp@n 5,901 on at
    RE: how to display company url through code in ssrs report.

    The below code is return the company url from companyinfo

    display URL url()
    {
        LogisticsElectronicAddress electronicAddress;
        electronicAddress = DirParty::primaryElectronicAddress(this.RecId, LogisticsElectronicAddressMethodType::URL);
        return electronicAddress ? electronicAddress.Locator : '';
    }
    Kindly let me know from GUI where it's ( company url ) is mentioned?
    Please give me more shed on this
  • WillWU Profile Picture
    WillWU 22,350 on at
    RE: how to display company url through code in ssrs report.

    Hi partner,

    If it is fixed, you can follow the link.

    The operations in D365 and AX are the same.

    You can show something descriptive by right-clicking the value and pick Placeholder Properties.

    pastedimage1586414223814v1.png

    Hope this helps.

  • Suggested answer
    Sukrut Parab Profile Picture
    Sukrut Parab 71,647 Moderator on at
    RE: how to display company url through code in ssrs report.

    Company info Table has URL method are you looking for that ? If yes , just find the company info table and call that method. You can assign value return through the method to your field in temp table.

  • @rp@n Profile Picture
    @rp@n 5,901 on at
    RE: how to display company url through code in ssrs report.

    Its might be dynamic or fixed , I don't know.

    The requirement is for AX 2012 R3

  • WillWU Profile Picture
    WillWU 22,350 on at
    RE: how to display company url through code in ssrs report.

    Hi @rp@n,

    Is your url dynamic or fixed?

    Please have a look at this old thread.

    community.dynamics.com/.../how-do-i-add-a-hyperlink-to-d365fo-ssrs-report

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans