How we can hide and show header/footer in cognos 10

Hi,

I am running one excel report in 2007 format which has conditional formating defined for header so that whenever user runs report in excel header will hide in the output.

But problem here is when we run the report in 2007 format we are getting one blank line in the 1st row of the report output. How can we fix this issue.

Currently we have migrated few of the reports from cognos 8.2 to cognos 10.1.
Now in all the reports which has conditional formating defined it is showing blank when we run the report in 2007 format. But it is showing correctly in html, csv & 2002 format.

Can any one please tel me how we can fix this ASAP, because we have many reports migrated from cognos 8.2 to 10. so we need to fix this issue all the reports.

Please find the attachment of the error details with snapshot.

Please repsond me ASAP.

Thanks
Gopi