RDL Formula Persist in Exported Excel RRS feed

  • Question

  • Hi All,

    I have a requirement as mentioned below.

    In my SSRS report, I have numeric data in multiple columns and a separate column as "Total" for summation of those multiple columns.

    Requirement : Once we export this report in Excel through SSRS, the "Total" column in excel should have summation formula in place by default. For this I guess the formula which we are setting in Total field in RDL file should persist in excel.  I am using the "SQL Server Data Tool For Visual Studio 2012"

    Request you to please suggest a solution.

    Thanks in Advance 

    Malini Johari

    Friday, March 28, 2014 6:21 AM

All replies