Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: cognos05 on 18 Nov 2014 07:48:24 AM

Title: view report in excel 2007 data
Post by: cognos05 on 18 Nov 2014 07:48:24 AM
 Hi All,

I am getting this below error when viewing the report in excel 2007 data format.

RSV-RND-0166 - Crosstab or chart is not supported in the Excel 2007 Data output format.

Is there any work around to remove this option, view in excel 2007 format is working fine.


Thanks,
Nithya
Title: Re: view report in excel 2007 data
Post by: bdbits on 18 Nov 2014 08:54:49 AM
No, crosstabs are not supported for Excel 2007 Data exports. It is really meant for list objects, kind of an alternative to CSV export.
Title: Re: view report in excel 2007 data
Post by: kc9400 on 18 Nov 2014 09:30:37 AM
Does the report contain a list also?

If so, you could possibly still get that part to export and set a render variable on the Chart/Crosstab so that it doesnt't get included in the export.

I'm not sure if that would be of any use though.
Title: Re: view report in excel 2007 data
Post by: cognos05 on 18 Nov 2014 09:59:45 AM
Most of our reports have crosstab, is there a way to hide this option?
Title: Re: view report in excel 2007 data
Post by: kc9400 on 18 Nov 2014 10:28:15 AM
I think the only way to currently remove the option is with a server wide change, so it will remove the option from all reports.

I'm unaware of a way to hide it on individual reports.
Title: Re: view report in excel 2007 data
Post by: bdbits on 18 Nov 2014 02:05:41 PM
Not by individual report, true, but you can secure certain interface elements by groups and roles, if you wish.

http://www-01.ibm.com/support/knowledgecenter/SSEP7J_10.1.0/com.ibm.swg.im.cognos.ug_cra.10.1.0.doc/ug_cra_id36310CustomizetheUserInterfaceBasedonGroupandR.html%23CustomizetheUserInterfaceBasedonGroupandRoleMembership (http://www-01.ibm.com/support/knowledgecenter/SSEP7J_10.1.0/com.ibm.swg.im.cognos.ug_cra.10.1.0.doc/ug_cra_id36310CustomizetheUserInterfaceBasedonGroupandR.html%23CustomizetheUserInterfaceBasedonGroupandRoleMembership)

The above article includes a link to the identifiers for the user interface elements.
http://www-01.ibm.com/support/knowledgecenter/SSEP7J_10.1.0/com.ibm.swg.im.cognos.ug_cra.10.1.0.doc/ug_cra_id53939ElementsYouCanHide.html%23ElementsYouCanHide (http://www-01.ibm.com/support/knowledgecenter/SSEP7J_10.1.0/com.ibm.swg.im.cognos.ug_cra.10.1.0.doc/ug_cra_id53939ElementsYouCanHide.html%23ElementsYouCanHide)

There was a discussion on this subject at http://www.cognoise.com/index.php?topic=22462.0 (http://www.cognoise.com/index.php?topic=22462.0) where Grim posted the above links.

Note that this just shows/hides interface elements, and the functionality might be unmasked using techniques like parameterized URLs.
Title: Re: view report in excel 2007 data
Post by: callmenagendra on 19 Nov 2014 05:56:20 AM
Hold CTRL key and run the report in excel 2007. Don't release the CTRL key until the report opens in excel.
Text only | Text with Images