Adding column heading of report by Editing Report XML

Introduction:

While using pivot table and one of the column uses measure label as column values, the column label will not appear in the results. This can be fixed by editing the report xml since the display is strictly based on the xml. Usually the column heading will come under a ‘header’ tag in the xml. This tag will be missing and it causes the issue. We have to find the location of this header under tag under ‘pivot table view’ in the xml and add appropriate codes to enable the column heading.

Steps:

The values in the second column are actually measure label. So it doesn’t have any column label.

Header format tag for the second column is missing in the XML.

Add header tag under “measure”,  referring to above tags.

After editing the xml, the column heading has come correctly.