COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Captain on 23 Oct 2014 01:54:39 PM

Title: Expand/Collapse Rows for Excel Output
Post by: Captain on 23 Oct 2014 01:54:39 PM
So there are javascripts out there to make HTML output have expandable/collapsible rows. However, what I am looking to do is to have these functionalities for when I generate the report in Excel. Has anyone been able to do this?

Thank you in advanced.
Title: Re: Expand/Collapse Rows for Excel Output
Post by: CognosAnalytics on 30 Oct 2014 02:54:18 PM
Hello Captain,
Javascript(HTML items), prompt UIs etc only show/work in HTML and no other format. Excel will only show your data containers eg: List, Crosstab, Charts etc. Not possible to pass on expand/collapse implemented within report studio to Excel or any other format except HTML.

-Cognos810