If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

excel saving as 2 rows

Started by fn4029, 01 Mar 2012 01:27:25 PM

Previous topic - Next topic

fn4029

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

Grim

"Honorary Master of IBM Links"- MFGF
Certified IBM C8 & C10 Admin, Gamer, Geek and all around nice guy.
<-Applaud if my rant helped! 8)

fn4029

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

Grim

"Honorary Master of IBM Links"- MFGF
Certified IBM C8 & C10 Admin, Gamer, Geek and all around nice guy.
<-Applaud if my rant helped! 8)