Post reply

Table Row visibility conditioning

  • July 20, 2018 at 4:27 am

    #358589

    Hi,
    I have a table with a row that I need to condition based on combination of a Parameter value and a Dataset field value, The Parameter is a NoYes Combo (Drop down list of 'No' and 'Yes' values only) and likewise, the Dataset output Field value can also only be 'Yes' or 'No'. Can this be done and is this the correct approach?

    Items:
    Parameters!noYesCombo.Value
    Fields!ShortFall.Value (the textbox is ReportItems!Shortfall.Value)

    Basically I understand the principal of the IIF statement in the 'Show or hide based on an expression' visibility option:
    =IIF(Parameters!noYesCombo.Value = "No", False, True)

    What I need is
    If Parameters!noYesCombo.Value = "No" (display ALL rows)
    If Parameters!noYesCombo.Value = "Yes" (display ONLY rows where Fields!ShortFall.Value = "Yes")

    I have tried several combinations of these together but I can't get it to work.
    =IIF(Parameters!noYesCombo.Value = "No", False, IIF(Parameters!noYesCombo.Value = "Yes" And Fields!ShortFall.Value = "Yes", False, IIF(Parameters!noYesCombo.Value = "Yes" And Fields!ShortFall.Value = "No", True, False)))

    Please can anyone help.

    Thanks in advance,

  • July 20, 2018 at 6:44 am

    #1998375

    Hi,
    I realise my error....

    I set the conditioning within the 'Row Visibility' instead of 'Row Group/Group Properties'. It made me feel humbled but at the same time, I think the distinction could be clearer.

    Still as least it works now.

    Sorry if I wasted anyone's time, it was a genuine mis-understanding of the use of both 'visibility filter' options. Up to now I wasn't aware that the' Row Group/Group Properties' filter was any different.

  • July 30, 2018 at 8:52 am

    #1999492

    While true, you may simply have hit upon a less than ideal report design.   Ideally, there's no reason to return data to the report that is just going to get hidden from view all the time.   Why not use the parameters to control what rows are returned in the dataset ?

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply