This is unusual problem and need a little explanation.
I have two tables with need to be presented in a parent-child bands.The unusual aspect of these two tables is that they have same set of fields. I won't go into the reasons for this unusual design.
So for example
table1 fields ---> A1 A2 A3 B1 B2 B3 table2 fields ---> A1 A2 A3 B1 B2 B3
In the parent-child bands, I plan to have the columns aligned i.e. no indentation between bands
But I want "A" fields to show only on parent band and the "B" fields aligned. So I want the display to be like this:
A1 A2 A3 B1 B2 B3 <--- parent band shows all fields B1 B2 B3 <--- child bands do not show fields A1, A2 and A3 B1 B2 B3 B1 B2 B3 A1 A2 A3 B1 B2 B3 B1 B2 B3 B1 B2 B3 A1 A2 A3 B1 B2 B3 B1 B2 B3
I think you are going to suggest setting the identation of the child band to start with the first "B" column. I have thought about that approach. There are other alignment and column sizing issue I would run into with that approach.
Ideally I would like to find a way so that for the child bands would present A1, A2 and A3 but with no values (blanks) in those columns. So in short is there a way I can display a column but make the value show blank?
Setting the ForeColor and BackColor is not a reliable way to do this, since the cells may change color if they are selected, activated, or if there is an ApplicationStyle applied. Much better to use the InitializeRow event of the grid and simply set the Hidden property on the cell to true.