web
You’re offline. This is a read only version of the page.
close
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

I have the same question (0)
  • Jon Frain Profile Picture
    Jon Frain 345 on at

    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.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    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

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

  • Jon Frain Profile Picture
    Jon Frain 345 on at

    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.

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    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.

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans