COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: lorenmario on 13 Jul 2011 08:50:35 AM

Title: Problem when I export from Report Studio 8.4 for Excel7
Post by: lorenmario on 13 Jul 2011 08:50:35 AM
Hello, I have a problem when I export a report from Report Studio 8.4 for Excel7, for every 3000 lines he makes a break and play in a new worksheet. I need to get the entire report in a single spreadsheet. Can anyone help me please?!  :)
Thanks
Title: Re: Problem when I export from Report Studio 8.4 for Excel7
Post by: jeemalif on 13 Jul 2011 09:02:52 AM
Usually, we add number of rows to avoid this (see attached screenshot). If your report is a complex one then you might need to play with page properties.

--Javed

Title: Re: Problem when I export from Report Studio 8.4 for Excel7
Post by: lorenmario on 13 Jul 2011 09:20:33 AM
Hello,
There is a limitation for this property lines?

Tks
Title: Re: Problem when I export from Report Studio 8.4 for Excel7
Post by: jeemalif on 13 Jul 2011 10:00:43 AM
Not sure what you mean. If you are asking whether there is a limit to maximum number of lines to be set, then I haven't come accross that limit yet. If you are telling that no matter what you specify, there is an internal limit that causes your reports to break before your set number then I'd be interested to know what that number is.

--Javed
Title: Re: Problem when I export from Report Studio 8.4 for Excel7
Post by: lorenmario on 15 Jul 2011 11:53:59 AM
Thanks!!!! :)