Renaming Crosstabe Colum Heading

[yogeshbhardwaj]

I have a cross tab query which give result like this



Date No. BoxItem1 BoxItem2 Item1 Item2
1-2-12 1 15 15 10 15
1-2-12 2 10 10
1-2-12 1 15 15
1-2-12 1 10 5 5 1

I need to BoxItem1 come after item1 and also col heading only box
Is it possible or not

Thanks in advance

[June7]

Cannot have multiple fields with the same name.

Crosstab will always order the rotated data by alphanumeric rules.

Are you building a report with the Crosstab? Arrange fields on report however you want and put whatever you want in labels.