How to eliminate repeated column titles in each block Cognos Excel Single sheet

[mohini7]

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

[mohini7]

Can u please share any idea, please

atleast where to start? is it possible???

Thanks in advance

[mohini7]

Please Help me

mohini

[mohini7]

??????????????

[mohini7]

oh god,

its strange

atleast is it possible or not

please

thanks in advance
mohini

[angela]

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.

[mohini7]

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

[blom0344]

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