Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Don't Display Field on Report - IF.....?

Avatar

Level 4

Hello - Has anyone created a report containing a field that only populates if the right selection is made? For example... If YES is selected, I want it on the report. If NO is selected, I don't want the NO or the Field Name to populate.

Let me know if any ideas? Thank you!

5 Replies

Avatar

Level 2

‚Hi, we have set up a report to show just those items with a yes against them on specific tasks. We set it up in Standard mode, but the below is what shows if I switch to Text mode. Governance Document Required is the column we are selecting Yes against.

DE:Governance Document Required=Yes

DE:Governance Document Required_Mod=in

Avatar

Level 4

Thank you, I should have been a tad more specific. I still want the task and other info to show regardless of the selection, just don't want the field showing on the report depending on the selection. For now, I just have it formatted to indicate NA if No is selected and shall do for now!

Avatar

Level 8

What I do is create a new column rule and put a space in the Show Text option.

0690z000008ZsdNAAS.pngWhat I do for that is make a new column rule, and use a space for the Show Text option:

Avatar

Level 4

Thank you, I've done that for now just to have it display NA. I would definitely do the space, however the field name will still populate but just show the "answer" as blank.

Avatar

Level 6

I might not be quite following, but are you trying to make the entire column itself disappear if a certain field is blank, or a report filter is answered a certain way?

If so, I think you could accomplish that in text mode by conditionally setting the width to 0 for that column if your condition were true. I'll be honest that I haven't tried it myself, but the basic building blocks to do that do exist.

That seems like an unusual use-case though, can you elaborate with a more specific example?

Katherine