In Bold Reports, you can dynamically rearrange table columns by utilizing code modules and report parameters. This technique enables you to define the column order through parameter values, offering flexibility and interactivity in your report design. It’s especially useful when applying custom column arrangements based on business rules or user preferences.

This guide outlines the steps to configure dynamic column reordering using code modules in Bold Reports.

Steps to Dynamically Rearrange Table Columns

1. Write a Custom Function in a Code Module
   • Open Bold Reports Designer.
   • Go to Report Properties and click the Code button.
   • Paste the following function into the code module dialog to extract the column name from a parameter based on its name:
     
     

   Public Function GetColumnValue(ByVal columnNum as Integer, ByVal parameter as Parameter) as String 
       Return parameter.Value(columnNum-1) 
   End Function

2. Create a Multi-Value Parameter
   
   
   • Click the Parameters icon to create a new Multi value report parameter to define the column order.
   • Assign default values that match the table’s column names (e.g., Login Id, Employee Id, Title, Manager Id).
     
     

3. Set Expressions for Table Columns Using the Code Module
   • Configure Table Headers:
     In the table’s header row, set the expression for each column header using the code module function.
     
     

=Code.GetColumnValue(1, Parameters!Order) 

• Configure Table Detail Rows
  In the details row of the table, set the expression for each cell to dynamically retrieve the field value based on the column order.
  
  

=Fields(Code.GetColumnValue(1, Parameters!Order)).Value 

4. Save and Preview
   When you preview the report, the table columns will rearrange dynamically based on the values selected in the Order parameter.
   Order:
   
   
   
   Re-Ordered type 1:
   
   

See Also

• How to hide columns in Table ReportItem using the report parameters?