I have a grid with 2 column headers.
How do I export both when exporting?
The top Header was created as
' -- REGISTRATION
'add an unbound header
With ch
.Caption = "REGISTRATION"
'set the origin to be on the top most level of the header
.RowLayoutColumnInfo.OriginY = 0
' set the newly added column to be in the correct location
ch.RowLayoutColumnInfo.OriginX = originX
'extend the newly added header over 4 columns
.RowLayoutColumnInfo.SpanX = 5
'add the header into the header layout
e.Layout.Bands(0).HeaderLayout.Add(ch)
originX += .RowLayoutColumnInfo.SpanX
End With