Print Page - character fields in full lenght :(

Title: character fields in full lenght :(
Post by: Kenneth on 12 Dec 2011 07:48:51 AM

Hi board members

We just updated from 8 to 10.
When I run reports in Excel, the fields shows full lenghts, causing all Excel formulars to fail as I have to trim.

Is it possible to disable this "full length" so fields only contains actual amount of characters and not a lot of blanks?

Title: Re: character fields in full lenght :(
Post by: cheriesheriff on 21 Dec 2011 10:40:01 AM

Have you tried using the TRIM functions? This will eliminate any space padding on the value (LTRIM removes left spaces, RTRIM removes right spaces).

Title: Re: character fields in full lenght :(
Post by: Kenneth on 02 Jan 2012 04:07:01 AM

Hi,

Yes I use trim for some reports, but I would like to avoid inserting Trim in +100 reports :)

Title: Re: character fields in full lenght :(
Post by: HalfBloodPrince on 02 Jan 2012 04:18:20 AM

Try to use trim in FM Then. But still its lots of work.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Kenneth on 12 Dec 2011 07:48:51 AM