Export to Excel Greyed out

[okh310]

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....

 

[AnalyticsWithJay]

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?

[okh310]

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?

[AnalyticsWithJay]

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