Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Business intelligence ...
Microsoft Dynamics AX (Archived)

Business intelligence and reporting

(0) ShareShare
ReportReport
Posted on by Aizaz Bhatti 20

Hello All,

I am customizing an inventory report and I want to add a textbox that should only display just for one company/legal entity.

For example, if there are 3 companies configured in my ERP environment Company A, Company B and Company C. They all are using same report for displaying data with same design. How can I add a textbox to the design of the report that should display itself only for the Company C?

I know that it can be done through expressions and I have tried many but not succeeded so far.

Any help in this matter is appreciated.

Thanks.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Business intelligence and reporting

    =iif(Fields!Company.Value = "A" OR Fields!Company.Value = "B", True, False)

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Business intelligence and reporting

    Hi Aizaz,

    Goto your textbox properties and select visibility, here you can find show or hide based on an expression.

    You can write expression like =iif(Fields!Company.Value = "A" OR Fields!CompanyName.Value = "B", True, False).

    Best Regards,

    Shaik Mohammed Khaja.

  • Ajit Profile Picture
    Ajit 8,755 on at
    RE: Business intelligence and reporting

    You can try expression of that text box in SSRS.

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans