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 / 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

I have the same question (0)
  • Ajit Profile Picture
    Ajit 8,755 on at

    You can try expression of that text box in SSRS.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    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.

  • Community Member Profile Picture
    Community Member on at

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

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 > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Sukrut Parab Profile Picture

Sukrut Parab 2 Moderator

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans