Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: chris2001dc on 10 Mar 2009 10:01:58 AM

Title: Hide columns in excel
Post by: chris2001dc on 10 Mar 2009 10:01:58 AM
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.
Title: Re: Hide columns in excel
Post by: Gollapudi on 11 Mar 2009 06:17:00 AM
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.
Title: Re: Hide columns in excel
Post by: chris2001dc on 11 Mar 2009 10:17:02 AM
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.
Title: Re: Hide columns in excel
Post by: billylodz on 11 Mar 2009 10:33:46 AM
use some combinations,  do the same with header , add crostab space if needed and hide for fact cels but not for header.....
Title: Re: Hide columns in excel
Post by: Gollapudi on 11 Mar 2009 11:41:26 PM
Hi,

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


Thanks,
Gollapudi.
Title: Re: Hide columns in excel
Post by: chris2001dc on 13 Mar 2009 10:02:13 AM
Thank you very much friends, I solve it with crosstab space and hiding and formating crosstab cells.

Title: Re: Hide columns in excel
Post by: PRIT AMRIT on 11 Jan 2011 02:00:08 AM
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
Title: Re: Hide columns in excel
Post by: jive on 11 Jan 2011 09:18:28 AM
Hi Prit,
Instead of removing the box, put background and foreground the same color. That's work to
Title: Re: Hide columns in excel
Post by: Arsenal on 11 Jan 2011 01:18:40 PM
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
Title: Re: Hide columns in excel
Post by: PRIT AMRIT on 11 Jan 2011 08:28:24 PM
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
Text only | Text with Images