List Cells appear wider for a report

[CVR]

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.

[CVR]

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.

[carollinho]

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

[CVR]

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

[carollinho]

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

[CVR]

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

Thanks.