SCROSS(Simple CrossTab)

For defining Scross we can used below xml tags.

< MAINGRID> < /MAINGRID> -> < MainGrid> is starting tag and < /MainGrid> is ending tag.

< SCROSS> < /SCROSS> -> < SCROSS> is starting tag and < /SCROSS> is ending tag.

TARGET -> We can set index of defined complex views in view in this tag if complex view is not define then we can set 0 for this tag.

PIVOT -> Assigned field to transform as header. Like Descrip

IDFIELD -> We can set unique key field for idfield. Like EmployeeID

AGGCOL -> We can set field to transform below header respective assigned column in pivot like Descrip. i.e Dated

Output ->