Header is not displaying when run the report in excel 2007 data format.

[kvchowdary]

Hi All,

We are using cognos 10.2 version and we are facing an issue with one of the list report,we have created a header for this and when we ran it excel 2007 data format it is not appearing and rest of the formats it is appearing.

Thanks
kv

[Applemdjs311]

Column header or actual report header (like report title)?

[kvchowdary]

Hi Applemdjs311,

Thanks for your response.

We need like report title

Thanks
kv

[bdbits]

Excel 2007 Data format is ... well, data. It's not supposed to be formatted. It is meant to be just the data from the first data container (list, etc) - for the user to do whatever with it in Excel.

[kvchowdary]

Hi bdbits,

I have to add some title to the report

thanks

[BigChris]

As bdbits says, if you view the report in "Excel 2007 Data" format you won't see the report headings...you'll see something that look similar to viewing the tabular data.If you pick "Excel 2007 Format" instead you should see your headings.

[kvchowdary]

Thanks Bigchris,

Actually i got request from the user to put some label in the header on the report.the report default format is excel 2007 data(user wants this format only)

Thanks

[Michael75]

From the Report Studio UG on Excel 2007 Data report output format:

This format is similar to a comma-separated values file (.csv). It has no formatting such as headers, footers, styling, or data formatting.

So, as others have pointed out, what you are requesting is not possible. What you may be able to do in your report is to strip out as much formatting as possible. Put your title in a block above your list, then turn off Page Header & Footer, in order to make it look like Excel 2007 Data format. But run it in Excel 2007 Format to keep the title in the output.

[nareshreddy.m]

Hi kvchowdary,

The below link may help you

http://www-01.ibm.com/support/docview.wss?uid=swg21444232

Thanks,
NR