SSRS – Repeat column headers on each page

Recently I was trying to show column headers when the table is growing and going to multi-page. Tried various options and then found this easy to show which I would like to share it here.

  1. Click on the column header, it will show Row Groups and Column Groups on the screen. Right click Column groups and click on “Advanced Mode”.

AdvanceMode

2. Click on Row Groups, click on “Static” and press F4 to go to the properties.

RowGroup

3. Click on Properties and set “KeepWithGroup” to After and “RepeastOnNewPage” to “True”

Rowproperties

That’s it, all good to go!

Advertisements

SSRS – Remove numbers or Text from a Field

I am very new to SSRS and there was a need to remove numbers from the value coming from DB. I found this quick way to write an expression to remove numbers or Text from a field in SSRS. Hope it would be useful to a newbie 🙂

System.Text.RegularExpressions.Regex.Replace(FieldValue,RegExPattern, ValueToReplace)

=System.Text.RegularExpressions.Regex.Replace(IIF(IsNothing(Fields!FieldName.Value), “”, Fields!FieldName.Value),  “[0-9]”, “”)

In a similar way to remove text from the string and to show only the numbers, here is the formula –

=System.Text.RegularExpressions.Regex.Replace(IIF(IsNothing(Fields!FieldName.Value), “”, Fields!FieldName.Value), “[^0-9]”, “”)