Author Topic: (un)group repeating cells in excel  (Read 388 times)

Offline vl9000

  • Associate
  • **
  • Join Date: Aug 2017
  • Posts: 2
  • Forum Citizenship: +0/-0
(un)group repeating cells in excel
« on: 21 Aug 2017 07:29:17 am »
Hi all,

maybe this has been asked before but I could not find it.

Compared to Report Studio, it seems the report property "(un)group repeating cells when exporting to excel" is missing in Cognos Analytics?
Is this correct and is there a reason why it was removed, or can we expect to have it available again in a future version?
Or, if the option is simply hidden somewhere, could anyone pls guide me on how to find it?

Thx.

Offline Lynn

  • Statesman
  • ******
  • Join Date: Apr 2008
  • Posts: 2,601
  • Forum Citizenship: +336/-1
Re: (un)group repeating cells in excel
« Reply #1 on: 21 Aug 2017 09:29:58 am »
Hi all,

maybe this has been asked before but I could not find it.

Compared to Report Studio, it seems the report property "(un)group repeating cells when exporting to excel" is missing in Cognos Analytics?
Is this correct and is there a reason why it was removed, or can we expect to have it available again in a future version?
Or, if the option is simply hidden somewhere, could anyone pls guide me on how to find it?

Thx.

There is an RFE logged for this functionality. It has a status of "Uncommitted Candidate" which means:
Quote
This request may not be delivered within the release currently under development, but the theme is aligned with the current multi-year strategy. IBM may consider and evaluate any RFE Community feedback for this request through activities such as voting. IBM will update this request in the future.

You need an IBM ID to view and vote for items.

https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=71510

This is the description which I think sounds like what you are asking:
Quote
Provide export functionality that maintains HTML Group/UnGroup capabilities to MS.  Today when a Users exports to Excel, the HTML formatting does not pass to the exported file. Targeted for WSA and Report Studio

Offline dougp

  • Statesman
  • ******
  • Join Date: Jul 2014
  • Posts: 272
  • Forum Citizenship: +14/-1
Re: (un)group repeating cells in excel
« Reply #2 on: 21 Aug 2017 02:05:11 pm »
Yes, it has been asked before...
The interim solution is to press CTRL+ALT+M to display the Report Studio menu.  Then open File | Report properties.

Offline vl9000

  • Associate
  • **
  • Join Date: Aug 2017
  • Posts: 2
  • Forum Citizenship: +0/-0
Re: (un)group repeating cells in excel
« Reply #3 on: 22 Aug 2017 02:38:03 am »
Thank you for your replies. I did not know that it was possible to open up the RS menu in this way, but it seems to do the trick. Thx.

 


       
Twittear