Hi everyone,
I know this is not specific to Dynamics GP, as Management Reporter 2012 (aka MR2012) is used cross product wise for many Dynamics ERP's.. but the point is that I cam across this yesterday while doing a restore of our production MR database to my new GP 2015 Test bed server and realized that our MR database had grown as large as our main GP company... (almost 12GB).. to me that first didn't made any sense, until I realized that we had generated a lot of report versions in the past 6 months since we were bought up by a new head company last year... As our CFO was trying alll kinds of report variation to find the proper way of reporting against new rules.
This led me to dive into the MR report history and that's were I found out that you can delete old generated reports either one version by one version, or the entire generated report. MR is too dumb as it offers only 2 options when using the delete button for a report : delete the last generated version or delete all versions. When selecting the 'all' version option, and depending on the number of generated reports, this can be a fairly lengthy process, as your MR Viewer will be busy for a while doing the delete, even becoming unresponsive.
Microsoft must come up with a better way of managing historical report version. I can't believe that there is not a more speedier way of getting rid of old versions and clean-up your database. We've been using MR since around 2012 and it had in the early stage only a very slow grow rate... Now with the amount of various report definitions that were built over the time and considering that we report against a dozen GP companies, this becomes an issue on the long run.
Has anyone found a better way of handling this ?
*This post is locked for comments
I have the same question (0)
