As I mentioned I have 3 levels in the grid. There is a possibility that sometimes the last band of grid may not have any data. Currently even if it does not have any data it shows the + sign in the parent and I am able to expand the grid and see nothing in it.

Is there anyway way I can stop the parent grid from showing any + sign if there are no rows in the child band?

Hierarchical grid provides initialDataBindDepth option. As you may assume from the options name it sets how many levels of the grid will be initially loaded. Option`s default value is -1 which means that initially all levels are going to be bound. In this case if you have a parent without any children the grid won`t render the "+" sign for expanding. Alternatively, if you set this option to 1, for example, and the third level is the one without children the grid does not have information about the data in the lower levels and will render the "+" sing in all cases.

I am attaching a small sample where the initialDataBindDepth option is not set (by default its is set to -1 which means that all data is loaded initially). In the third level there is no data respectively on the second level the "+" sign is not rendered. If you set the initialDataBindDepth option to 1 you may observe that in the second level the "+" sign is rendered.

Pleas let me know if you have any additional questions regarding this matter.

In case that you are using igHierarachicalgrid with LoadOnDemand the "+" sign for expanding will always be visible. The reason is that igHierarachicalGrid has no information about the child levels until they are requested by clicking the expand icon. Some further information about Load On Demand feature may be found here.