none
Add the formula to the formula bar in excel RRS feed

  • Question

  • In SQL reporting, How do I add the formula in the Formula bar?

    All the data is coming from a sproc


    www.helixpoint.com

    Tuesday, September 1, 2015 5:41 PM

Answers

  • Hi Helix, 

    According to your description, you want to see the expression in the excel file after exporting to excel, right? 

    In Reporting Services, text box values that are expressions are not converted to Excel formulas. It's because the text box values evaluated during report processing and the evaluated expression is exported as the contents of each Excel cell. This work mechanism is by design. So for your requirement, it cannot be achieved currently. 

    Reference: 

    Exporting to Microsoft Excel (Report Builder and SSRS)

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

    Regards,
    Shrek Li

    Wednesday, September 2, 2015 2:38 AM
    Moderator

All replies

  • You have to write SSRS expressions Go through below link

    https://msdn.microsoft.com/en-IN/library/ms345237.aspx


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

    Tuesday, September 1, 2015 5:47 PM
  • I am doing all the calculations in SQL, but they want to see the formula in the formula bar in excell

    www.helixpoint.com

    Tuesday, September 1, 2015 6:44 PM
  • Hi Helix, 

    According to your description, you want to see the expression in the excel file after exporting to excel, right? 

    In Reporting Services, text box values that are expressions are not converted to Excel formulas. It's because the text box values evaluated during report processing and the evaluated expression is exported as the contents of each Excel cell. This work mechanism is by design. So for your requirement, it cannot be achieved currently. 

    Reference: 

    Exporting to Microsoft Excel (Report Builder and SSRS)

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

    Regards,
    Shrek Li

    Wednesday, September 2, 2015 2:38 AM
    Moderator