Finally realised that we cannot make changes to the linked report, like editing the column names. Work around is i made a copy of the base report on my local machine. Edited using the report builder and uploaded it to the same folder.

Open the linked report properties and click on change the link button and point it to the new report.

Thanks