Hide columns in excel

[chris2001dc]

Hi,

I am working with Cognos 8.3, I have a problem when I open a report with Excel, I hide 2 columns, when I run the report HTML the columns are not show this is OK, but when I run it with Excel the columns appear. Is there any way to hide the columns in Excel.

Thanks.

I attach a picture for you to undestand better.

[Gollapudi]

Hi,

I Tried it, if you take of the that text "Double click the text to edit" and make the boxtype  "none", that will works fine.


Thanks,
Gollapudi.

[chris2001dc]

Hi, thanks for your answer.

I tried but when I make the boxtype none a column moves to the left, but the header of the column doesn't move.
So,

                      | valor1  | valor2
Total Ag           |   25    |    35
Ag1    |     15    |    20   |
Ag2    |    10     |   15    |

Is there another way to hide the columns???

Please help.

[billylodz]

use some combinations,  do the same with header , add crostab space if needed and hide for fact cels but not for header.....

[Gollapudi]

Hi,

I forgot to mention this, you will have to use crosstab space and format it...


Thanks,
Gollapudi.

[chris2001dc]

Thank you very much friends, I solve it with crosstab space and hiding and formating crosstab cells.

[PRIT AMRIT]

Hi,

Could you please fine the attached screenshot and help me out to fix the issue.

This is a Cross-tab report. The 'Red' color highlighted part is the Column that i have used for grouping and the same is set to 'Box Type'=NONE, since i want to hide it. This works fine in HTML.

However, when i render the report to EXCEL, the values are not showing the but the 'ROW' is still showing. As shown in the screenshot.

Any suggestion how to hide the same?

Thanks
P

[jive]

Hi Prit,
Instead of removing the box, put background and foreground the same color. That's work to

[Arsenal]

You could also try the following link and see if that works for you. It has a solution for box type None issues in a crosstab

https://www-304.ibm.com/support/docview.wss?uid=swg21340044

[PRIT AMRIT]

Jive,

In fact I have been trying the same approach and finally did it with a small trick.

I put a table with 4 columns in side the QTR column, then applied the color column wise, since excel always considers the number of columns.

FYI, attached the screenshot of the work around.

Thanks man.

P