locked
SSRS 2012 - How to show hovering data in Exported Excel Report RRS feed

  • Question

  • Hi All,

    We are showing hovering data in the report. When we hover the pointer of the mouse over cell, it shows the data. But when we export the report in excel, hover functionality is not working in exported report. We are looking for help in finding the solution to ensure hovering should work in the exported excel report.

    Thanks,

    Vishal Jharwade

    Wednesday, September 23, 2015 2:04 AM

Answers

  • Hi Vishal, 

    According to your description, you want to keep the ToolTip feature when exporting to excel, right? 

    As Milan mentioned, this feature is not available in Excel. In Reporting Services, we can add ToolTip to the text box so that we can display the expected data. But in Excel, there is no ToolTip feature, it has a similar feature Screen Tip. Enable Screen Tip in Excel can display the text box data when the cell is too small and the data cannot be displayed completely. Please refer to the following image: 

    For your requirement, the ToolTip is not supported in Excel. We can try to work around your requirement by adding comments to the cells or using Data-Validation. Please refer to the following articles: 

    Excel Sheet Hover Over Cell To Display Data

    Microsoft Excel: Add A Tooltip To A Cell

    If you have any other question, please feel free to ask. 

    Regards, 
    Shrek Li

    • Proposed as answer by 王者荣耀 Wednesday, October 7, 2015 9:02 AM
    • Marked as answer by 王者荣耀 Thursday, October 8, 2015 8:38 AM
    Thursday, September 24, 2015 6:58 AM

All replies

  • Hi Vishal,

    Currently this feature is not available in SSRS. This is a limitation when we export the report to different formats.

    Already people have brought this into notice.For more info please check the below link

    https://connect.microsoft.com/SQLServer/feedback/details/404285/ssrs-export-tooltips-to-excel-as-comments


    Please Dont forget to mark as answer and Helpful Post. It helps others to find relevant posts to the same question. Milan Das

    Wednesday, September 23, 2015 4:40 AM
  • Hi Vishal, 

    According to your description, you want to keep the ToolTip feature when exporting to excel, right? 

    As Milan mentioned, this feature is not available in Excel. In Reporting Services, we can add ToolTip to the text box so that we can display the expected data. But in Excel, there is no ToolTip feature, it has a similar feature Screen Tip. Enable Screen Tip in Excel can display the text box data when the cell is too small and the data cannot be displayed completely. Please refer to the following image: 

    For your requirement, the ToolTip is not supported in Excel. We can try to work around your requirement by adding comments to the cells or using Data-Validation. Please refer to the following articles: 

    Excel Sheet Hover Over Cell To Display Data

    Microsoft Excel: Add A Tooltip To A Cell

    If you have any other question, please feel free to ask. 

    Regards, 
    Shrek Li

    • Proposed as answer by 王者荣耀 Wednesday, October 7, 2015 9:02 AM
    • Marked as answer by 王者荣耀 Thursday, October 8, 2015 8:38 AM
    Thursday, September 24, 2015 6:58 AM