24

Below is the report I have created. I would like to draw a line after every group as depicted with red line in the image.
Tried meddling with Textbox Properties > Border Style expression. But that would not stay once I close and reopen it.
If I set border for whole group, the line would repeat for every row in group which I dont want.

Any help?

enter image description here

Null Head
  • 2,877
  • 13
  • 61
  • 83
  • 2
    If your conditional formatting is not sticking when you run your report, try checking this post out: http://www.joellipman.com/articles/microsoft/reporting-services/479-border-settings-not-saving-in-ssrs.html –  Feb 08 '12 at 16:40

6 Answers6

40
  1. Click on the View tab in Microsoft SQL Server Report Builder.
  2. Ensure the Properties check box is checked so that the Properties window is shown.
  3. For the ProductionCountry select the entire group row. The properties should show for the row.
  4. In the properties dig down to Border->BorderStyle->Top. The value will more than likely be blank.
  5. In the Top field, enter the expression below for the top border.

Top field value:

=IIF(Fields!ProductionCountry.Value = Previous(Fields!ProductionCountry.Value) OR Fields!ProductionCountry.Value = First(Fields!ProductionCountry.Value, "mydataset"),"None","Solid")

Change mydataset value above to match the dataset name of your report.

Note:

If current row belongs to the same group as the previous row OR current group row is the first of the dataset, set border to none, set border to solid.

Community
  • 1
  • 1
niktrs
  • 9,858
  • 1
  • 30
  • 30
  • Amazing use of expressions! I needed visibility of a line between instances of a group but not on the last one so I used your expression and just looked to make sure it wasn't the last one. – Jt2ouan Feb 28 '15 at 22:43
5

To improve on @niktrs's answer, I would suggest:

=Iif(Fields!ProductionCountry.Value = Previous(Fields!ProductionCountry.Value) OR IsNothing(Previous(Fields!ProductionCountry.Value)),"None","Solid")


This has the advantage of not adding a line on the initial group row, even when the first group displayed isn't the first group in the dataset, for example where sorting or filtering is in place.

Gary Pendlebury
  • 336
  • 5
  • 8
5

Select the entire detail row and add this expression to the BorderStyle-Top property:

=IIF((Previous(Fields!ProductionCountry.Value) <> Fields!ProductionCountry.Value) 
    OR (Previous(Fields!IndustryName.Value) <> Fields!IndustryName.Value) 
    OR (Previous(Fields!ProductGroup.Value) <> Fields!ProductGroup.Value), 
    "Solid",
    "None")
Chris Latta
  • 20,316
  • 4
  • 62
  • 70
2

What I found really easy to do is define the top border for the group. In this way each new group adds a border between the last row of the previous group and the first one of the new group. It also adds a border after the headers.

This solution does not draw a border at the end of the last row. If you need that border too, you can define the bottom border for the tablix that contains the groups.

Edgar Hernandez
  • 4,020
  • 1
  • 24
  • 27
0
=Iif(Fields!ProductionCountry.Value ="","None","Solid")

also change the border default none left solid right solid bottom none top the above expression. and to the rectangle properties change bootom order..

i tried like this for the top border and it was working fine...

Lijo
  • 6,498
  • 5
  • 49
  • 60
0

In my case I have an aggregate value so I cant use previous function so I hard coded the first value from the group which I knew that is going to be the first value in that group.Then in Border Style I used this expression

Top =iif(Fields!Group_Name.Value="Hard Corded(first value)","Solid","None")

Also in Border Color used this expression 

=iif(Fields!Group_Name.Value="Hard Corded(first value)",,"Black","LightGrey")
santosh
  • 799
  • 5
  • 17
Pvishal
  • 1