Due to the lack of data binding support in page headers on SQL Server Reports I found this code online that allows you to grab info from fields in the details section of the report and display them in the header. The code is as follows:
Function GetItemValue(ByVal Items As ReportItems, ByVal item As String) As String
This works great when viewing in HTML but when I export this report to any format the code gets ignored and the fields in my page header are blank. Is there any way around this?