COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: okh310 on 29 Jun 2016 03:01:39 PM

Title: Export to Excel Greyed out
Post by: okh310 on 29 Jun 2016 03:01:39 PM
Hi -

I have a multi-page dashboard with the report toolbar enabled.  I noticed when I click on a tab and try to export to excel, it's greyed out. 

I have another dashboard and it is not greyed there.  The reports in my dashboard are report views.  I did a test and changed them back to the original reports instead of using the report views and got the same issue. 

Has anyone seen this before and how do I fix this?  I've attached a screenshot of what I see....

 
Title: Re: Export to Excel Greyed out
Post by: AnalyticsWithJay on 30 Jun 2016 07:35:42 AM
The default behavior on Viewer portlets is to show the most recent saved output version. If it shows an HTML saved output version, the remaining icons will be disabled.

As a test, could you go into the properties of the Viewer portlet and set the behavior to run the report?
Title: Re: Export to Excel Greyed out
Post by: okh310 on 30 Jun 2016 08:54:45 AM
Thank you for the response CognoidJay! 

I did a test and looks like you are correct!  If I run the report and save the output as excel, my dashboard displays the tab as excel and when I click export, it shows ONLY the excel option.  However, this isn't very helpful in our situtation.  I want the user to view the tab as HTML and be able to export to excel for sorting/filtering. 

Any ideas how to achieve both?
Title: Re: Export to Excel Greyed out
Post by: AnalyticsWithJay on 30 Jun 2016 09:22:22 AM
You're welcome :)

I haven't tested this, but if you set the run option in the Viewer to Run the Report, you should be able to export to all options that are enabled by your admin.

Jay