ssrs 2008 no rows message

  • In an ssrs 2008 report, I placed a no rows message into a tablix when applicable. The problem is the ssrs report places a black border around the entire tablix. This is fine whn data exists. However when there is no data, is there a way that I can remove the black border so that it does not display?
    If so, can you tell me how to accomplish my goal?

  • wendy elizabeth - Tuesday, June 6, 2017 5:12 PM

    In an ssrs 2008 report, I placed a no rows message into a tablix when applicable. The problem is the ssrs report places a black border around the entire tablix. This is fine whn data exists. However when there is no data, is there a way that I can remove the black border so that it does not display?
    If so, can you tell me how to accomplish my goal?

    Look at the border property for the tablix as you can set the border style to an expression. Or the color depending on what you want. If you have the style set to double or whatever, you can set it to none if there is no data in your dataset.
    =IIF(CountRows("DataSet1") > 0, "Double", "None")

    You could also hide the tablix if you want - set the hidden property of the tablix:
    =IIF(CountRows("DataSet1") > 0, False, True)

    Sue

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

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