How to add a line/separator between groups?


  • Hi,

    I have a simple report with multiple grouping. I like to add a separator between groups.

    Some data (Group #1)

    =================  <----- separator line or color row or something

    Some data (Group #2)




    Thursday, July 20, 2006 6:07 PM

All replies

  • You could use the footer of a group as the seperator between groups. If there is no footer for the group, you can set it in the properties of the group (rightclick the group and select properties) I think this is what you want!


    Thursday, July 20, 2006 7:46 PM
  • What I do is merge all the columns in the report for the Group Header & Footer textboxes. Then, for the Group Header textbox, I set the border style of the top of the textbox to Solid, and I do the same for the bottom of the Group Footer textbox.


    Thursday, March 15, 2007 11:02 PM
  • hi

    is there any way I can put seperator for the columns in a matrix

    i.e. if one column group is finished then its border should be different color?



    Thursday, August 11, 2011 12:37 PM
  • Hi,

    I Bold my lines between groups using the Previous() function. If the Previous value of the group by field is different then set BoarderWidth = 1.5 else BoarderWidth = 1.

    So in the BoarderWidth Top Expression for each cell I want bolded I put...

    =IIF(Previous(Fields!GroupID.Value) <> Fields!GroupID.Value ,"1.5pt","1pt")

    In this example GroupID is the field the data is grouped on. The same method can be used for color.

    Hope this helps.
    • Edited by Bluey47 Monday, October 01, 2012 2:11 AM formating
    Monday, October 01, 2012 2:10 AM