How can we Hide/show Data table column at runtime by input checkbox list element

Dipak Gunjkar

• August 30, 2021 13:08
• Edited

Hi

I have used Input checkbox list element to list the data table columns when I select checkbox of any column header that column Header should be disappear form Grid and when I deselect checklist that column display again at a time same functionality should be applied for multiple option..

Thanks

0

• 

  VISUI

  • Logi Info Ninja
  • September 14, 2021 15:43

  Dipak,

  You can get similar functionality with the Analysis Grid, with most options turned off (if desired).

  
  
  

  <AnalysisGrid ID="AnalysisGrid1" ShowPageNumber="True" SortArrows="True" DraggableColumns="True" AjaxPaging="True" HideAgAggr="True" HideAgChart="True" HideAgCrosstab="True" HideAgFilter="True" HideAgFormat="True" HideAgCalc="True" HideFunctionNamesDefault="True" HideAgGroup="True" HideAgPaging="True" HideAgSortOrder="True">
  <DataLayer Type="XMLFile" ID="XMLFileDataLayer1" XMLFile="C:\inetpub\wwwroot\VISUIClients\_SupportFiles\NW_Orders.xml" />
  <AnalysisGridColumn ID="colOrderID" Header="OrderID" DataColumn="OrderID" DataType="Number" />
  <AnalysisGridColumn ID="colCustomerID" Header="CustomerID" DataColumn="CustomerID" DataType="Text" />
  <AnalysisGridColumn ID="colEmployeeID" Header="EmployeeID" DataColumn="EmployeeID" DataType="Number" />
  <AnalysisGridColumn ID="colOrderDate" Header="OrderDate" DataColumn="OrderDate" DataType="Date" Format="Short Date" />
  <AnalysisGridColumn ID="colRequiredDate" Header="RequiredDate" DataColumn="RequiredDate" DataType="Date" Format="Short Date" />
  <AnalysisGridColumn ID="colShippedDate" Header="ShippedDate" DataColumn="ShippedDate" DataType="Date" Format="Short Date" />
  <AnalysisGridColumn ID="colShipVia" Header="ShipVia" DataColumn="ShipVia" DataType="Number" />
  <AnalysisGridColumn ID="colFreight" Header="Freight" DataColumn="Freight" DataType="Number" />
  <AnalysisGridColumn ID="colShipName" Header="ShipName" DataColumn="ShipName" DataType="Text" />
  <AnalysisGridColumn ID="colShipAddress" Header="ShipAddress" DataColumn="ShipAddress" DataType="Text" />
  <AnalysisGridColumn ID="colShipCity" Header="ShipCity" DataColumn="ShipCity" DataType="Text" />
  <AnalysisGridColumn ID="colShipPostalCode" Header="ShipPostalCode" DataColumn="ShipPostalCode" DataType="Number" />
  <AnalysisGridColumn ID="colShipCountry" Header="ShipCountry" DataColumn="ShipCountry" DataType="Text" />
  <AnalysisGridColumn ID="colShipRegion" Header="ShipRegion" DataColumn="ShipRegion" DataType="Text" />
  <WaitPage />
  </AnalysisGrid>

   

  0

Please sign in to leave a comment.