SSRS Add Table to Report Header / Footer

Question

A relatively basic question that seems to elude me is whether it is possible to insert a table in the header or footer of an SSRS report?

I can only get the following options: Text box, line, rectangle, image

However, basically I get a lot of controls that I can add. Is this a limitation of SSRS? Are there any workarounds other than “creating" tables using a combination of text fields?

It is worth mentioning that I am using SQL Server 2008 R2 Report Builder 3.0.

Thanks!

Answer 1

SSRS does not allow Tablix in the header and footer. SSRS only allows static data in the header and footer. To access dynamic data, we usually use ReportItems or Parameters . To add a tablix (table), a dataset is required. That is why we cannot add tablix to the header and footer.

MSDN article in report headers and footers