How to Add a SubGrid Custom Widget in Bold BI

In this article, you will learn how to create and use a SubGrid custom widget in Bold BI. The custom widget can be published in two types: Type 1 and Type 2.

Publishing the Custom Widget

1. Download the SubGrid custom widget from the attachment section. 
2. Publish the custom widget to the Bold BI application using the help link.
3. Once published, you can find the SubGrid custom widget under the Miscellaneous section of the designer panel.

  
SubGrid In Miscellaneous section.

Configuring Type 1 SubGrid - Merge cells in Grid 

Follow these steps to configure a Type 1 SubGrid:

1. Bind data to the widget.


Bind data to the SubGrid.

1. Configure the ID column index in the properties panel. The ID column can be changed based on your requirement. You can also enable/disable the ID column in the grid widget using the “Show ID Column” property. Cell merging will only work when the Sub Report Type is set to Type 1.SubGrid Configured with ID Column Index.

Note: If the ID column index is empty, it will automatically take the first column bound to the widget as the ID column.

Configuring Type 2 SubGrid

Follow these steps to configure a Type 2 SubGrid:

1. Bind data to the widget.


Bind Data to the SubGrid.

1. Configure the ID column index in the properties panel. The ID column can be changed based on your requirement. You can also enable/disable the ID column in the grid widget using the “Show ID Column” property. Value separation by comma will only work when the Sub Report Type is set to Type 2.SubGrid configured with Id column index.

Note: If the ID column index is empty, it will automatically take the first column bound to the widget as the ID column.

Additional References

• Bold BI Website
• Custom Widgets in Bold BI