web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Management Reporter Backup for Reports and Folders

(0) ShareShare
ReportReport
Posted on by 55

Doing an Export in Management Reporter will not export te folders only the Reports. Does anyone have a solution for this?

Let me know

Thanks

Categories:
I have the same question (0)
  • Suggested answer
    Lisa at AonC.com Profile Picture
    933 Super User 2025 Season 2 on at

    If you are comfortable with SQL and have access to the ManagementReporter database, I can give you a hint on this with the latest releases of MR:

    -You need to insert the folder information from the original ManagementReporter.reporting.ControlFolder table.

    -The reports are assigned to the folder in the reporting.ControlReport table.  The folder is stored in the FolderID column.  (I was able to do this with UPDATE scripts where I read in the data form the original ManagementReporter database.)

    [I have only had to complete this process once for a client so I am not comfortable releasing any actual scripts.  It was very fast and easy to do once I found the data.  ]

    Once I got the folders inserted and the reports updated to the FolderID, I confirmed I could see them properly represented in Report Designer.

    [If you don't have the original ManagementReporter database, you could create the missing folders and then update the FolderID based on the newly created folders you see in the ManagementReporter.reporting.ControlFolder table.]

  • Brig214 Profile Picture
    55 on at

    Hi Lisa,

    Thanks for your reply, this was very helpful. Is there some documentation on the content of all the MR tables.

    Let me know

  • Lisa at AonC.com Profile Picture
    933 Super User 2025 Season 2 on at

    I don't know where the tables may be actually documented, but the table names are usually descriptive enough (and accurate) that I can quickly find what I am looking for. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 611 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 529 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans