Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: mohini7 on 29 Dec 2009 10:19:17 AM

Title: How to eliminate repeated column titles in each block Cognos Excel Single sheet
Post by: mohini7 on 29 Dec 2009 10:19:17 AM
Hi could you please help me with below issue,

i am using 8.3, i have a report in cognos report studio, it has a cross tab in it, when i open the report in excel version single sheet, it displays differemt blocks and for each block it shows the column headings repeatedly, how can i make it to show just starting af the report (one time for the whole page) without any page breaks(just want to disply top to bottom)

i tried setting up rows per page property but it took lot time to run the report is there any other thing that i can see
please......

help me , thanks in advance
mohini
Title: Re: How to eliminate repeated column titles in each block Cognos Excel Single sheet
Post by: mohini7 on 29 Dec 2009 11:18:04 AM
Can u please share any idea, please

atleast where to start? is it possible???

Thanks in advance
Title: Re: How to eliminate repeated column titles in each block Cognos Excel Single sheet
Post by: mohini7 on 29 Dec 2009 11:50:50 AM
Please Help me

mohini
Title: Re: How to eliminate repeated column titles in each block Cognos Excel Single sheet
Post by: mohini7 on 29 Dec 2009 01:28:36 PM
??????????????
Title: Re: How to eliminate repeated column titles in each block Cognos Excel Single sheet
Post by: mohini7 on 29 Dec 2009 03:22:55 PM
oh god,

its strange

atleast is it possible or not

please

thanks in advance
mohini
Title: Re: How to eliminate repeated column titles in each block Cognos Excel Single sheet
Post by: angela on 29 Dec 2009 04:12:19 PM
Many people only check the forum once a day - or less - so posting repeatedly doesn't really help you get answers.

In answer to your question, I just tried running a crosstab report to Excel and as a PDF it has multiple pages but in Excel there are no weird blocks and no additional headers.  To me this indicates that your report spec has some unusual formatting in it, like blocks or tables or something.
Title: Re: How to eliminate repeated column titles in each block Cognos Excel Single sheet
Post by: mohini7 on 29 Dec 2009 06:23:29 PM
hi angela,

thanks for your reply, thanks for your information on forum actually i am new to this forum,

anyway sorry for all whom ever get annoyed on this post,

now relate to my report , yes i do have a table(which has 4 cells) in my crosstab corner cell, but does it affect the output?

Can i make a try to stop as being blocks in any manner

please.....?

Thanks in advance
mohini
Title: Re: How to eliminate repeated column titles in each block Cognos Excel Single sheet
Post by: blom0344 on 30 Dec 2009 02:41:43 PM
Quote from: mohini7 on 29 Dec 2009 06:23:29 PM

now relate to my report , yes i do have a table(which has 4 cells) in my crosstab corner cell, but does it affect the output?


The proof is in the pudding  :)
Create a copy of the report and simplify the design, chucking the table out of the corner cell, then test.
Honestly, this is much more conclusive than asking whether a populated corner would be the cause of your problem. We'd like to put in some advice, but you need to test yourselve
Text only | Text with Images