Home Forums Reporting Services SSRS 2016 Issue with tota column when export to Excel RE: Issue with tota column when export to Excel

  • September 14, 2017 at 8:06 am

    #1959438

    mcfarlandparkway - Tuesday, September 12, 2017 2:51 PM

    There is a value for Total Column for Front end Report but it is not showing when we export to Excel

    data looks like in the front end as
             0.0%
             0.0%
             0.0%
    Total 0.0%

    when I generate report to excel column is showing empty, it should get these values correct? do I need to check excel format of that column?

    Post your actual SQL query that generates the data.   Understand that Excel doesn't handle certain data types very well.  Often, things that you want as numbers end up text in Excel, which can cause all manner of grief.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)