Home Forums Reporting Services Reporting Services export report to excel and excel should create formula fields for the sum fields of the report RE: export report to excel and excel should create formula fields for the sum fields of the report

  • Yes Chad I believe you are correct, I have bumped into this and found that you cannot export formulas except in text to excel reports eg:

    your RS expression would look like ="(C1 + B4)*52" when exported to excel you can push F2 and it will calculate tha value.

    so it is kind of crude/half *** but it is an excel formula.

    JK..