Search code examples
reporting-servicesgroup-byborderhiddenrow-number

How do you create a boarder in an SSRS Report?


I've gotten the hang of creating charts/colors and grouping data but I can't seem to figure out how to outline each grouping in my report.

enter image description here

I've got data built for my chart - what I would like to have it appear as -- is like this:

enter image description here

I'm not picky on the color, but that's the least of my worries. I can't figure out how to create the outline, but by group rather then by line.


Solution

  • For your TOP Border Style, use the expression:

    =IIF(Fields!TourDate.Value = PREVIOUS(Fields!TourDate.Value), "None", "Solid")
    

    This just checks to see if your TourDate field is different from the Previous row.

    The default would need to be solid. You can use it with the border color (black) instead if you want the grey border normally.