Print Page - excel saving as 2 rows

Title: excel saving as 2 rows
Post by: fn4029 on 01 Mar 2012 01:27:25 PM

Hello,

When I run report in report studio and output to excel 2007, is there a way to keep the column to one row? No matter what I try, can't get report to save to one row, uses 2 rows for columns that have long entries even though column size is big enough (pls see attached screenshot, I want example 1 and 3 to look like example 2). I tried changing Positioning/Size & Overflow to 100 in, Font & Text/Spacing & Breaking to Keep all, etc. but nothing working. Thanks for help!

using Report Studio 8.4 and Excel 2007, column is Varchar257

Thanks!
fn4029

Title: Re: excel saving as 2 rows
Post by: Grim on 01 Mar 2012 02:49:29 PM

Try this. Should fix it.
http://www-01.ibm.com/support/docview.wss?uid=swg21440556

Title: Re: excel saving as 2 rows
Post by: fn4029 on 02 Mar 2012 09:05:36 AM

Thanks Grim!

this is great forum. I used to have access to Cognos Support, but think this forum is much better! I just have to get the Cognos Admin to put this thru.

Thanks again!
fn4029

Title: Re: excel saving as 2 rows
Post by: Grim on 02 Mar 2012 09:37:33 AM

Cheers! :)

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: fn4029 on 01 Mar 2012 01:27:25 PM