Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Management Reporter Ro...
Microsoft Dynamics SL (Archived)

Management Reporter Row definitions saved to a file?

(0) ShareShare
ReportReport
Posted on by Jon Frain 345

Hello,

I'm still working on issues that have arisen when we pushed SP2.  Right now I'm trying to get Management Reporter to generate reports.  In most case the reports will generate, but in at least one case the row definitions have had their links to financial dimensions disappear completely.

My IT department is working on putting a backup of the machine up and so worst case I can manually reproduce those links.

I'm wondering if Management Reporter actually stores the row definitions to files somewhere on the machine and I just haven't found them yet.

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Management Reporter Row definitions saved to a file?

    I understand.  I still believe it would be possible to make a backup of the current Management Reporter database, restore a backup of that same database before the problem occurred, open the row definition for the affected report, copy that into Excel, restore the current backup, open the bad row definition and paste the Excel rows back into the current row definition over the bad definitions.  It depends on how many rows are involved and whether this effort would save time over just redefining the rows.

    If you are brave and comfortable with SQL you could also restore the older Management Report database to an alternate database name and create an update query to update various rows in the active database table with data from the alternate database.  Again, it is a questions as to which gets the issue resolved quicker.

  • Jon Frain Profile Picture
    Jon Frain 345 on at
    RE: Management Reporter Row definitions saved to a file?

    One complicating factor may be the fact that we updated management reporter and it updated the database as a result.

    It may be easier to reconstruct the faulty reports instead.

    Thanks again.

  • Jon Frain Profile Picture
    Jon Frain 345 on at
    RE: Management Reporter Row definitions saved to a file?

    Thank you very much for this information.  Hopefully we still have those old table entries

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Management Reporter Row definitions saved to a file?

    Management Reporter stores all of the report definitions in a SQL database named MangementReporter.  The row definitions are stored in a table named ControlRowDetail and ControlRowCriteria.  There are several other tables that handle the linkage to catalogs and such so you need to be careful if picking and choosing various tables to restore.  You might be best off to restore the entire ManagementReporter database from a recent backup but be advised that you will loose any database changes related to Management Reporter changes since that backup.

  • Jon Frain Profile Picture
    Jon Frain 345 on at
    RE: Management Reporter Row definitions saved to a file?

    I should mention that it's management reporter 2012.

    I also don't see any way to export definitions once we get this straightened out and want to make backups.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,884 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,760 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans