Issue when exporting report to Excel as Excel 2007 Format

[valiant]

Hi,

    I used Cognos 10.2 to design report. My report worked well as HTML output. However, when I exported report to Excel as Excel 2007 Format, some data was not corrected. Example: some cells viewed "Dennis Hirata" and some cells viewed "DennisHirata ". Space between FirstName and LastName was removed and one space added to last string. When I exported report to Excel as Excel 2002 Format, the result is good (as HTML format). How can I fix this issue when exporting report to Excel as Excel 2007 Format?  :o

Thanks
Valiant

[raj_aries81]

Hi Valiant

Howabout including trim for both the dataitems (first name & last name) and then concatenating, just a thot :)

Regards
Raj

[valiant]

Hi,

   Both first name and last name were  the string in one columns in database (not 2 columns). Why did Cognos export to Excel 2007 as "strange" data ? How can I fix this issue ?

Thanks
Valiant

[BigChris]

Check the raw data on the server and make sure that there's no records on there for DennisHirata...look for any record that starts with "Dennis%" (depending on what platform you're using... you haven't said). Cognos doesn't alter the data by stripping out spaces as far as I know, so I think you're possibly seeing the same data but in a different sequence.

[valiant]

Hi BigChris,

    MS SQL 2012 is my data source. It deployed on Windows server 2008. I checked data from database and no rows are "DennisHirata ". How can I fix this issue ?   :'(

Thanks