Don't Display Field on Report - IF.....? | Community
Skip to main content
J
JordanMa
Level 4
July 2, 2020
Question

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

  • July 2, 2020
  • 4 replies
  • 876 views

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!

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    4 replies

    E
    ElaineHe
    Level 2
    July 6, 2020

    ‚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

    J
    JordanMaAuthor
    Level 4
    July 7, 2020

    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!

    A
    AdinaPi1
    Level 9
    July 9, 2020

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

    What I do for that is make a new column rule, and use a space for the Show Text option:

    J
    JordanMaAuthor
    Level 4
    July 9, 2020

    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.

    K
    Community Advisor
    KatherineLaCommunity Advisor
    Community Advisor
    July 9, 2020

    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

    Terms & ConditionsAccessibility statement

    Loading footer...