Download TOT formulas to Microsoft Excel from a Management Reporter report (CU10 Feature)


One of the most voted for features for Management Reporter in Microsoft Connect is the ability to include formulas when downloading reports to Microsoft Excel. In Management Reporter 2012 CU10, users will be able to include TOT row formulas in downloaded Excel files.

Check out the video below to see this feature action:

https://youtu.be/1OM-A6JKi9c

Comments (11)

  1. Kathy Youngquist says:

    I can't view YouTube from our network (it's blocked), but the concept sounds great.  Thanks for adding that to MR.

  2. Jill Carter says:

    Hi Kathy, Here's a bit more detail for you. There's now an option in the report definition to include formulas as part of the Excel download. Rows that have TOT formulas will have the formulas downloaded as part of the Excel download.

  3. Pam Robertson says:

    Do you know if there are plans to add other formulas in the future, like column calculations?

  4. Natalie Godwin says:

    I would echo Pam Robertson.  We would like to export Column Calculations.  Am I missing something or is this not available in the current version?  If not available, when will this be made available?  This is integral in our reporting process.

    Thank you.

  5. Chasity Thompson says:

    I also would like to see Column calcuations added.  Not being able to export colunn formulas is still a huge limitation for us.

  6. Jill Carter says:

    Thanks for all of the feedback. Two additional suggestions have been entered for formulas, one for CAL rows and one for CALC columns. Please use the links below to vote.

    connect.microsoft.com/…/include-calc-column-formulas-when-downloading-reports-to-excel

    connect.microsoft.com/…/include-cal-row-formulas-when-downloading-reports-to-excel

    Voting on these suggestions will help us prioritize features for upcoming releases.

  7. sally higgins says:

    when exporting to excel with formulas I get error messages "variable x" has a data row value of "x-1" which was not found in the variableOffsets", but I can export without errors if I don't check the box for formulas.

  8. Jill Carter says:

    @Sally – we've released a hotfix for CU10 that should fix the issues you are seeing when downloading formulas. You can download it here: mbs.microsoft.com/…/MROverview

  9. Hi Jill,

    We experience the same issue as Sally Higgins with the strange error message about the VariableOffsets.. but we don't use the DataMart, only the legacy connector on our production system. Will the fix work equally for the legacy and the DM connector ?

  10. Jill Carter says:

    @Beat – Yes, it will also work for legacy.

  11. Wilson Robert says:

    Thanks of sharing this helpful information with us. learn more about advanced excel and VBA macros visit http://www.advancedexcel.net/

Skip to main content