Other Wiki Sections

Printing Forms using Report Parameters - SSRS

SQL Server Reporting Services does not permit placing field values in the Page Header and Page Footer sections of a report, at least not with the Field!FieldName.Value syntax. This article explains a work-around for this in SSRS 2005 by caching the header data in hidden report parameters.

(1) Modify your SQL statement for the header records. Modifying your SQL this way avoids the error message Parameter 'ParameterName' is missing a value when the original SQL finds no records. Note the addition of the HasData column. You can use this column to easily check if your SQL is returning a legitimate row or the "dummy" row.