Problem when exporting to Excel 2002. The percentage column loosing format
Posted: Jun 19, 2012 12:08:08 AM
Click to report abuse... Click to reply to this thread Reply
Attachment export issue.bmp (1.0 MB)
Hello
I have a report studio cross tab report which has a percentage column, formatted as "percent" by two decimal places.
The calculation for the column is (count(a)/count(b)).
When the report is exported to excel 2002 or even CSV, it looses its formatting.
for example :33.33 % in HTML is exported as .33 % ,38.10 % is exported as .38 %,100% exported as 1.00 %.
I have attached a snapshot about how it looks in the HTML and Excel.
I am using a Cognos 10.1.1 and Using DB2.
Any help would be greatly appreciated.