Post reply

Hide alternate rows depending on value of row in SSRS Tablix

  • July 2, 2015 at 4:02 pm

    #302147

    Hi there,

    How do I hide rows depending on the values of one of the rows.

    I have a tablix with two rows.

    1st row will always have nothing in it. 2nd row might have an address in it sometimes.

    I want to hide the 1st row if the 2nd row has an address and then hide the 2nd row if it is empty leaving the 1st row.

    I have tried the row visibility and tablix visibility but think I am missing something. It is not doing what I thought it would do.

    This is what I have tried on the row visibility for each row. Not both at once.

    = Iif (CountRows() > 0, false, true)

    =IIF(IsNothing(ReportItems!Address2.Value),True,False)

    What am I missing........ ?

    Thanks

    Regards

    Angie

  • July 2, 2015 at 4:14 pm

    #1810086

    Are you just trying to filter out the records that do or do not meet some criterion? If so, use a Filter and tie it to a parameter value, so the user can choose what he wants to see.

  • July 2, 2015 at 4:40 pm

    #1810094

    Thanks for responding.

    No I want to show a row where they can write an address in or display the address if one has already been added.

    So I am pulling data on a customer, form to be printed off.

    If they have an Address, print that, if they do not have an address show the row with the boxes to fill out.....

  • July 2, 2015 at 4:56 pm

    #1810095

    You do realize that reports are read-only, right? You can prompt for parameters, but only before the report is run. That would be the only place you could modify what shows up in the report.

  • July 2, 2015 at 5:02 pm

    #1810097

    Yea, actually I do.........

    they will be printing the form off..... so would be nice if there was no address to have a line that they can fill in on the printed form

  • July 2, 2015 at 5:07 pm

    #1810098

    You might be able to set the VISIBLE property of the control in the report based on the value in it... other than that, I'm not sure how you would do it.

  • July 2, 2015 at 5:14 pm

    #1810102

    yes, that is what I am trying to do but it is not behaving how I thought it would.

    I am using the Row Visibility options.

    I have attached what it looks like.

  • July 9, 2015 at 7:17 am

    #1811294

    Hi Angie

    What is the expression you used for the rowvisibility ?

    :w00t: !!!GOOGLE IS YOUR BEST FRIEND!!! :w00t:

Viewing 8 posts - 1 through 7 (of 7 total)

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