rchiu5hk said:

How can I make the column header to have multiple lines or auto fit in multiple lines with the header text if needed??

Take a look at the ColHeaderLines and WrapHeaderText properties on the band. One or both of these should help you achieve what you want.

rchiu5hk said:

How to prevent the layout of end of the columns as shown below?

It's hard to tell from the screen shot but that looks like a ColScrollRegion Splitter.To turn this off, you can set:

grid.DisplayLayout.MaxColScrollRegions = 1;

There's a similar property for MaxRowScrollRegions.