If you are unable to create a new account, please email support@bspsoftware.com

 

Cognos 10 conver text to number in a mixed data type column when run as excel

Started by sean, 12 Nov 2014 10:15:03 PM

Previous topic - Next topic
Print
Go Down Pages1
User actions

sean

12 Nov 2014 10:15:03 PM Last Edit: 13 Nov 2014 09:11:57 PM by Sean
Hi, in my Cognos report there is a column call Item Code which contains numeric codes as well as normal string codes:

Item Code
12345 (stored as text)
GS001 (normal string)

When run as Excel report, the numeric codes are stored as text in the excel cell. Is it possible to setup Cognos report in a way that when run as Excel the numeric codes are stored as number (instead of text) in excel cell?

Many thanks,

Sean
Print
Go Up Pages1
User actions
BSP Software Documentation
MetaManager Documentation and Knowledgebase
Version Control Documentation and Knowledgebase
BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel Micro Strategies Inc
Security Migration IBM Cognos
Integrated Management Suite