Thank you, the table appears ideal to me on the surface, but I have never understood how it could be implemented in a grouped scenario. Currently I do the following for datasource assignment and leverage groups with header and detail. All database processing is handled outside of the report layer.
Partial Public Class DetailCrosstabWide
Public Sub New(ByVal _lightcolor As Color, ByVal _DarkColor As Color, ByVal _RepTitle As String, ByVal _dt As DataTable)
txt1.Style.BackgroundColor = _lightcolor
txtTitle.Style.BackgroundColor = _DarkColor
txtTitle.Value = _SvyTitle
Me.DataSource = _dt
Since every group will have different headers, I would need to understand how I could access the header values (which are columns in the datatable) either as a value from the page datasource, or some other method.
datatable structure is basically the following grouped by groupnametext
groupnametext rowtext1 col1headertxt1 col1val col2headertxt col2val