Print Page - List Cells appear wider for a report

Title: List Cells appear wider for a report
Post by: CVR on 24 Sep 2008 08:52:51 AM

Hi Folks,

I am newbie to COGNOS... I created a list and populating with the query results. The actual data size of one column in sybase database table is varchar(512)... Not surprisingly there are lot of whitespaces for many rows.

When the report is produced, I am getting all cells wider. I tried to use trim(x), but still the List cells are wider. How Can I get rid of this and get a neat report.

Eagerly waiting for a response....

Thanks.

Title: Re: List Cells appear wider for a report
Post by: CVR on 24 Sep 2008 08:58:13 AM

And when I run report excel-2002, I am getting this column as series of ####### instead of displaying the actual data in the excel cells.

Title: Re: List Cells appear wider for a report
Post by: carollinho on 26 Sep 2008 10:40:41 PM

Try to specify size in the properties for your column but you will need to experiment with the size.

Title: Re: List Cells appear wider for a report
Post by: CVR on 29 Sep 2008 02:47:04 AM

Thanks for responding. I tried playing with size, but unable to get any good results :-[

Title: Re: List Cells appear wider for a report
Post by: carollinho on 29 Sep 2008 09:03:29 PM

Can you do a cast to shorten the data fields? And also play with report format?

Title: Re: List Cells appear wider for a report
Post by: CVR on 13 Oct 2008 02:26:16 AM

The trim is working as expected when I set SourceType to "Report Expression" and it solved the problem....

Thanks.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: CVR on 24 Sep 2008 08:52:51 AM