reportbuilder3.0

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

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

Sql PIVOT and string concatenation aggregate

In order to get the result, first you should concatenate the values into the comma separated list. I would use CROSS APPLY and FOR XML PATH: SELECT distinct e.[Event Name], e.[Resource Type], LEFT(r.ResourceName , LEN(r.ResourceName)-1) ResourceName FROM yourtable e CROSS APPLY ( SELECT r.[Resource Name] + ‘, ‘ FROM yourtable r where e.[Event Name] = … Read more