Search code examples
reporting-servicesssrs-2008ssrs-tablix

SSRS 2008 Tablix bold just one row?

Is there a way, in SSRS to have just one row on a table (Tablix) highlighted if that one row has important information for the user.  Let's say, for example, I wanted the first row in bold.  How would I make that happen?

I think the syntax is =IIF(ROWNUMBER(NOTHING)= 1, "#FF0000", Nothing)

I managed to make my table morph from this:

Col 1        Col 2        Col 3    
[Col_1]        [Col_2]        [Col_3]

to this:

Col 1        Col 2        Col 3    
Expr    [Col_2]        [Col_3]

But should the expression for Value be:

=Fields!Col_1.Value

=IIF(ROWNUMBER(NOTHING)= 1, "#FF0000", Nothing)
Solution

  • Set the background color property or font weight based on whatever your criteria is. You can use ROW_NUMBER() to check if it's the first row. Something like

    =IIF(ROWNUMBER("yourDatasetName") =1, "#FF0000", Nothing)