Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Border on Matrix Row Group

Status
Not open for further replies.

andrea96

Programmer
Jan 26, 2001
201
US
I'm trying to add a border to the bottom of each row group, but I can't figure out how. My row group may have up to three lines of data, but I only want the border on the bottom of the last line of the group. When I select the matrix row and add a border, it applies it to every row. Is there a way to apply the border at the group level?
Thanks,

Andrea
 
I've come up with somewhat of a solution. I added a field to my underlying table and stored procedure to store the sub-row and added a group for the sub-row in the matrix. Then, I added an expression to the Top Border Style.
Code:
=IIf(Fields!sub_row.Value = 1, "Solid", "None")
I did have to move some of my grouping logic from my matrix to my stored procedure to keep the values summarized, but it seems to be doing what I wanted now.

Andrea
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top