Print Page - How to set the output format of a data column to be enclosed by double quotes?

Title: How to set the output format of a data column to be enclosed by double quotes?
Post by: LR on 24 May 2012 07:26:36 AM

I have a report spec and in which i need a couple of columns to be displayed with a double quotation.I googled and added the RSVP.CSV.QUALIFIER propeerty in the cognos admin console system properties tab. How do i modify the report spec to allow double quotes to be displayed?

Also, I clicked the play symbol in the report studio to run the current report spec in csv format ,but after the prompt page it disappears. Can someone help?

Title: Re: How to set the output format of a data column to be enclosed by double quotes?
Post by: jmills on 24 May 2012 05:20:36 PM

Edit the data item expression like that of the following:

'"'+[Date Item]+'"'

(Single quote, double quote, single quote +[Data Item]+ single quote, double quote, single quote)
use all 6 quotations and validate.

Output should show "Data Item"

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: LR on 24 May 2012 07:26:36 AM