or

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If Not Page.IsPostBack Then DisplayPrintOptions.DataSource = GetPrintDisplayProfile() DisplayPrintOptions.DataBind() end ifPrivate Function GetPrintDisplayProfile() As DataTable 'Get users Preferred Layout Dim dt As New DataTable() dt.Columns.Add(New DataColumn("ColumnDisplayName", GetType(String))) dt.Columns.Add(New DataColumn("Column", GetType(String))) dt.Columns.Add(New DataColumn("Display", GetType(Boolean))) dt.Columns.Add(New DataColumn("Print", GetType(Boolean)))etc..<telerik:RadComboBox ID="DisplayPrintOptions" runat="server" HighlightTemplatedItems="true" Width="100px" AutoPostBack="false" Label="Display & Print Options:" LabelCssClass="DisplayPrint-label" DropDownWidth="400" EmptyMessage="- Select -"> <HeaderTemplate> <div style="width:305px;height:15px;"> <div style="display:block;float:right;color: rgb(0, 21, 110) !important;"> Show in </div> </div> <div style="width:350px;"> <div style="width:210px;float:left;padding:0 11px 0 11px;color: rgb(0, 21, 110) !important;"> Name of Column </div> <div style="width:50px;float:right;margin-right:5px;color: rgb(0, 21, 110) !important;"> Report </div> <div style="width:40px;float:right;color: rgb(0, 21, 110) !important;"> Grid </div> </div> </HeaderTemplate> <ItemTemplate> <ul id="DisplayPrint"> <li> <!-- Row --> <ul> <li id="col1"><%# Eval("ColumnDisplayName")%></li> <li id="col3"> <telerik:RadButton ID="ColReports" runat="server" ButtonType="ToggleButton" ToggleType="CheckBox" Checked='<%# DataBinder.Eval(Container.DataItem, "Display").ToString()%>' AutoPostBack="false" CommandName='<%# DataBinder.Eval(Container.DataItem, "Column").ToString()%>'> </telerik:RadButton> </li> <li id="col2"> <telerik:RadButton ID="ColGrid" runat="server" ButtonType="ToggleButton" ToggleType="CheckBox" Checked='<%# DataBinder.Eval(Container.DataItem, "Print").ToString()%>' AutoPostBack="false" CommandName='<%# DataBinder.Eval(Container.DataItem, "Column").ToString()%>'> </telerik:RadButton> </li> </ul> </li> <!-- End of row --> </ul> </ItemTemplate> <FooterTemplate> <div style="float:right;"><telerik:RadButton ID="SubmitColumns" runat="server" Text="Submit" CausesValidation="false" OnClick="BuildGridColumns" /></div> </FooterTemplate> </telerik:RadComboBox><telerik:RadPivotGrid Width="100%" AllowPaging="true" OnNeedDataSource="RadPivotGrid1_NeedDataSource" ID="RadPivotGrid1" runat="server" ColumnHeaderZoneText="ColumnHeaderZone" EnableToolTips="true" AllowFiltering="true" ShowFilterHeaderZone="false" ErrorValue="0" AllowSorting="True" > <ClientSettings EnableFieldsDragDrop="true"> <Scrolling AllowVerticalScroll="true" /> </ClientSettings> <Fields> <telerik:PivotGridRowField DataField="field1" Caption ="field1"> </telerik:PivotGridRowField> <telerik:PivotGridRowField DataField="field2" Caption ="field2"> </telerik:PivotGridRowField> <telerik:PivotGridRowField DataField="field3" Caption ="field3"> </telerik:PivotGridRowField> <telerik:PivotGridRowField DataField="field4" Caption ="field4"> </telerik:PivotGridRowField> <telerik:PivotGridColumnField DataField="field5" Caption ="field5"> </telerik:PivotGridColumnField> <telerik:PivotGridColumnField DataField="field6" Caption ="field6"> </telerik:PivotGridColumnField> <telerik:PivotGridColumnField DataField="field7" Caption ="field7"> </telerik:PivotGridColumnField> <telerik:PivotGridColumnField DataField="field8" Caption ="field8"> </telerik:PivotGridColumnField> <telerik:PivotGridAggregateField DataField="field9" Aggregate="Sum" Caption ="field9" > </telerik:PivotGridAggregateField> <telerik:PivotGridAggregateField DataField="field10" Aggregate="Sum" Caption ="field10" > </telerik:PivotGridAggregateField> <telerik:PivotGridAggregateField DataField="field11" Aggregate="Sum" Caption ="field11" > </telerik:PivotGridAggregateField> <telerik:PivotGridAggregateField DataField="field12" Aggregate="Sum" Caption ="field12"> </telerik:PivotGridAggregateField> <telerik:PivotGridAggregateField DataField="field13" Aggregate="Sum" Caption ="field13"> </telerik:PivotGridAggregateField> <telerik:PivotGridAggregateField DataField="field14" Aggregate="Sum" Caption ="field14"> </telerik:PivotGridAggregateField> <telerik:PivotGridAggregateField DataField="field15" Aggregate="Sum" Caption ="field15"> </telerik:PivotGridAggregateField> <telerik:PivotGridAggregateField DataField="field16" Aggregate="Sum" Caption ="field16"> </telerik:PivotGridAggregateField> <telerik:PivotGridAggregateField DataField="field17" Aggregate="Sum" Caption ="field17"> </telerik:PivotGridAggregateField> </Fields> <ClientSettings> <Scrolling AllowVerticalScroll="true"></Scrolling> </ClientSettings> </telerik:RadPivotGrid>