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
Hi Valiant
Howabout including trim for both the dataitems (first name & last name) and then concatenating, just a thot :)
Regards
Raj
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
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.
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