News and Announcements icon

Dynamics 365 CommunityForums 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) Share

Report

Report

Posted on by Community Member Microsoft Employee

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 ;)

All responses Img

All responses (1)

Answers Img

Answers (0)

a33ik 84,323 Most Valuable Professional on at

Like (1)

Report

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

Hello,

Try to use following:

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

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans