0

I'd like to add an extra line after every category in SSRS..Not sure how to do this?

enter image description here

Brian Tompsett - 汤莱恩
  • 5,753
  • 72
  • 57
  • 129
RoseChris
  • 51
  • 1
  • 1
  • 6
  • 2
    Did you check [this](http://stackoverflow.com/a/13258700/2647648)? – alejandro zuleta Aug 23 '16 at 18:58
  • 1
    Possible duplicate of [How to create a report with sections and page breaks using SSRS](http://stackoverflow.com/questions/13257276/how-to-create-a-report-with-sections-and-page-breaks-using-ssrs) – Idan Aug 24 '16 at 03:21

1 Answers1

1

Create a second blank detail row above the detail row with your fields on it. Select this second blank detail row and in the Visibility-Hidden property, put the expression:

=Fields!category.Value = Previous(Fields!category.Value)

In other words, when the category field on this row is the same as the previous category, hide the blank line. So when they aren't the same, the blank line appears.

Chris Latta
  • 20,316
  • 4
  • 62
  • 70