reportbuilder3.0

Report Builder 3.0 SWITCH expression DEFAULT/ELSE

by

There is no default clause in the SSRS Switch expression. However, you can always modify your expression slightly: =Switch ( Parameters!UserFranNr.Value = “99”,”ID99″, Parameters!UserFranNr.Value = “87”,”ID87″, true, “ID0” ) Since any time the last condition is hit it will be explicitly evaluated to true, the last row will effectively act as a default value. I’ve … Read more

Tablix: Repeat header rows on each page not working – Report Builder 3.0

by

It depends on the tablix structure you are using. In a table, for example, you do not have column groups, so Reporting Services does not recognize which textboxes are the column headers and setting RepeatColumnHeaders property to True doesn’t work. Instead, you need to: Open Advanced Mode in the Groupings pane. (Click the arrow to … Read more