RDL Formula Persist in Exported Excel

• Question

• 

  

  0

  Sign in to vote

  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