Fixed row headers on SSRS 2008 R2

As you would have noticed, this doesn’t work out of the box in SSRS 2008 R2.

This is a little tricky.

So, the needed steps are the following:

  1. Select your Tablix.
  2. On your Tablix Properties General tab, uncheck “Keep header visible while scrolling” (This was supposed to work out of the box)
  3. On the panel below, you will see Row and Columns Groups.
  4. On the upper right corner, click and Select “Advanced Mode”.
  5. Now, on Row Groups, click on the first item “(Static”).
  6. On its Properties, set “Keep with group”, “Fixed data”  and “Repeat on new page” to TRUE.

Done!

Further references:

Freezing column headers while scrolling in SSRS

Keep Column Headers Visible while scrolling in SSRS 2008

Keep Column Headers Visible while scrolling in SSRS 2008

Fixed Row and Column Headers in Matrix in SSRS 2008 R2

Controlling Row and Column Headings (Report Builder 3.0 and SSRS)

Fixed row headers on SSRS 2008 R2

Repeating Tablix Headers In SSRS 2008

Responder

Introduce tus datos o haz clic en un icono para iniciar sesión:

Logo de WordPress.com

Estás comentando usando tu cuenta de WordPress.com. Cerrar sesión / Cambiar )

Imagen de Twitter

Estás comentando usando tu cuenta de Twitter. Cerrar sesión / Cambiar )

Foto de Facebook

Estás comentando usando tu cuenta de Facebook. Cerrar sesión / Cambiar )

Google+ photo

Estás comentando usando tu cuenta de Google+. Cerrar sesión / Cambiar )

Conectando a %s

A %d blogueros les gusta esto: