SSRS: Setting the bottom border based on the grouping

ssrs-2008 ssrs-grouping
temitaio picture temitaio · Oct 5, 2011 · Viewed 8.7k times · Source

I would like to apply a bottom border to my report based on the first group

I have 3 groups: Parent: Region Child 1: City Child 2: Area

I want the border applied to the bottom on the last row of the group, based on the parent group: Region.

I am currently trying this (In the Top option of border style) but it is not working perfectly

=IIF(RunningValue(Fields!Region.Value, CountDistinct, "Region") MOD 2 = 1,"Solid", Nothing)

Please help!!!!

Answer

temitaio picture temitaio · Oct 7, 2011

I have resolved this without using an expression.

  • I added a parent group in the row group
  • Selected the option 'Add group footer'
  • Highlighted the bottom row and set the border style (bottom) to 'solid'

That does it!

Related questions

How to sum the Group totals only?

I'm trying to sum only group HourTarget totals. 7:00 8:00 HourTarget Line 1 2715 1008 3224 A 2307 1008 3224 B 408 0 3224 Line 2 2308 2432 2656 A 2308 2432 2656 Line 3 2318 1622 2800 A 345 1258 2800 B 762 0 2800 C 1211 364 2800 I'm trying to achieve 8680 as a result of sum of HourTarget. But I'm getting 17504. It is because HourTarget in a database table …

Read More
How to create a report with sections and page breaks using SSRS

I'm trying to create a report that looks like this: using a select from this table: (fiddler here for query and data) CREATE TABLE StudentData ( id int PRIMARY KEY IDENTITY, name varchar(30), subject varchar(30), currentGrade varchar(2), targetGrade varchar(2), note1 varchar(100), …

Read More
Is it possible to create a row that spans all columns of a Matrix in SSRS 2008?

Is it possible to have add a row to an SSRS 2008 Matrix that spans all of the matrix's columns? This crude diagram shows roughly what I'm looking for: The basic idea is that each line item is a person, and …

Read More