COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS Connection => Topic started by: RubenvdLinden on 08 Dec 2009 07:12:45 AM

Title: Disable report output formats
Post by: RubenvdLinden on 08 Dec 2009 07:12:45 AM
Is it possible to disable certain report output formats such as Excel 2002?
It keeps crashing in our Citrix environment whilst Excel 2007 and Excel 2002 Single Sheet work fine.
Title: Re: Disable report output formats
Post by: CognosPaul on 08 Dec 2009 08:52:38 AM
Modified slightly from a similar problem in the technotes:
http://www-01.ibm.com/software/data/cognos/products/cognos-8-business-intelligence/support (http://www-01.ibm.com/software/data/cognos/products/cognos-8-business-intelligence/support)

Problem(Abstract)
Excel 2002 option in Cognos Viewer needs to be hidden

Resolving the problem
Edit the file "c8_location/templates/ps/portal/system.xml" Steps:

   1. Stop the Cognos 8 service.
   2. Open the c8_location/templates/ps/portal/system.xml file in an XML or text editor (Please take a backup of this file before editing).
   3. Use the following syntax in the <system> element to hide a user interface element:
      <param name="ui_hide">
      <RV_TOOLBAR_BUTTONS_XLS_XLWA/>
      </param>
   4. Save the file
   5. Start the Cognos 8 service.

Note: There can be only one <param name="ui_hide"> element in system.xml. Therefore, all
items you want to hide must be placed inside this element.
Title: Re: Disable report output formats
Post by: RubenvdLinden on 29 Jan 2010 06:10:01 AM
Sorry for my late response, I forgot to tick the notify option  ;D
I will definitely try this tonight and post back the results.
Title: Re: Disable report output formats
Post by: RubenvdLinden on 29 Jan 2010 08:52:21 AM
It works like a charm, thank you very much!

Is there also a parameter to return the 'View tabular data' button in the toolbar of Report Studio 8.4?
Title: Re: Disable report output formats
Post by: MFGF on 29 Jan 2010 09:06:56 AM
Quote from: RubenvdLinden on 29 Jan 2010 06:10:01 AM
Sorry for my late response, I forgot to tick the notify option  ;D

Hi,

I know you're kidding, but in case others don't pick up on this, please only use the Notify (report to moderator) option for reporting spam - it sends a message to all admins and moderators of the forum.

Thanks for the update too - Paul is a star! :)

MF.
Title: Re: Disable report output formats
Post by: RubenvdLinden on 29 Jan 2010 09:52:30 AM
I meant the 'Notify me of replies' option, not the spam reporting option.
Title: Re: Disable report output formats
Post by: MFGF on 29 Jan 2010 10:01:46 AM
Just checking!  ;)  ;D
Title: Re: Disable report output formats
Post by: CognosPaul on 01 Feb 2010 05:28:50 AM
Quote from: RubenvdLinden on 29 Jan 2010 08:52:21 AM
It works like a charm, thank you very much!

Is there also a parameter to return the 'View tabular data' button in the toolbar of Report Studio 8.4?

I'm very glad to hear that it works.

It looks like an enhancement request has been submitted to re-add the button: http://www-01.ibm.com/support/docview.wss?uid=swg21368464 (http://www-01.ibm.com/support/docview.wss?uid=swg21368464)

One of these days I'm planning on sitting down and cracking open the UI of Report Studio. There are a number of changes I'd like to make, but at this point I don't even know where to begin.