We have updated Flexmonster Software License Agreement, effective as of September 30, 2024. Learn more about what’s changed.

Group multiple columns with top header

Answered
Ravi Kumar asked on February 13, 2021

Hi,
I need to group different columns and top of them need to have a header with appropriate information.
Please find the attachment.
We have 3 columns Quantity, Percentage, Rate which comes under "Closing Information" same with other columns, we need to show in the view from the attachment.
Please provide any solution to achieve this functionality.
 
Regards,
Ravi Kumar

Attachments:
Grouping Issue.PNG

5 answers

Public
Milena Pechura Milena Pechura Flexmonster February 16, 2021

Hello, Ravi,
 
Thank you for posting to our forum.
 
Our team would like to inform you that Flexmonster does not provide an option to show grouping headers on the grid.
 
We suggest considering a workaround that adds a row with grouping headers. Please follow the steps below:

  1. Hide component's headers (column numbering) and the Toolbar. Here is a code snippet for reference:
    toolbar: false,
    options: {
    grid: {
    showHeaders: false
    }
    }
  2. Add a custom row with grouping headers ("Closing information" and "Opening information") above the Flexmonster component. This solution means placing the row outside of the Flexmonster instance.

Please kindly note that using the described approach, the new row will not be exported.
If the export of this row is needed, the custom export functionality should be implemented. We suggest specifying params.destinationType as "plain" in the exportTo() method to modify the exported file in the callbackHandler function.
 
Hope it helps!
 
Kind regards,
Milena

Public
Ravi Kumar February 17, 2021

Hi Milena,
Thanks for the response.
We can add custom row with group headers but is it possible to align them in specific positions? because like i mention in the previous attachment we can get more columns.
With the above possibility we need to show group headers on top of only those mentioned columns and these columns grouply come at any place like starting, ending or middle.
So could you help me with that.
 
Regards,
Ravi Kumar

Public
Milena Pechura Milena Pechura Flexmonster February 19, 2021

Hi, Ravi,
 
Thank you for providing further explanations.
 
According to the suggested approach, the grouping headers can be placed in the new row in any desired order.
Could you please confirm that you want to add the headers in the flat view? If it is correct, you can check the order of columns in the slice and consider this info when adding the row above the component.
 
Hope it helps!
 
Best regards,
Milena

Public
Ravi Kumar March 3, 2021

Hi Milena,
We need to add in Classic/Compact layout.
We're yet to implement the suggested solution due to other priorities it is getting delayed. Will let you know about the result for sure.
 
Regards,
Ravi

Public
Milena Pechura Milena Pechura Flexmonster March 3, 2021

Hello, Ravi, 
 
Thank you for the heads-up!
 
We will be looking forward to further updates.
 
Kind regards,
Milena

Please login or Register to Submit Answer