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 365 | Integration, Dataverse... / How to hide a table if...
Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

How to hide a table if a condition is true/false?

(0) ShareShare
ReportReport
Posted on by Community Member

Hey guys,

with the Report Builder (SQL Server 2016) I have created a layout for one of my reports.

On a RequestPage I added a bool field "LoadWithoutData", which the user can set to true/false.

Now if this field is set to true/false, some tables should be hidden on the report layout.

How can I achieve this?

I have seen that the tables have some properties: "Text Box Properties"

If I select them, I can change the visibility.

But I do not know the syntax...

3010.Syntax.PNG

The field on the RequestPage I also added to the layout, so I can select it here.

So I can write something like this:

=Fields!LoadWithoutData.Value == False

When I run the report, is says that an error has occured, but it say not, which one..

Thanks ;)

I have the same question (0)
  • a33ik Profile Picture
    a33ik 84,331 Most Valuable Professional on at

    Hello,

    Try to use following:

    =(Not First(Fields!LoadWithoutData.Value, "Put your dataset name here"))

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 365 | Integration, Dataverse, and general topics

#1
Martin Dráb Profile Picture

Martin Dráb 41 Most Valuable Professional

#2
iampranjal Profile Picture

iampranjal 39

#3
Satyam Prakash Profile Picture

Satyam Prakash 35

Last 30 days Overall leaderboard

Featured topics

Identifying an Org as CDS or Dynamics
Get batch job history log from D365 FO to Power Automate
Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans