Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Automated Deletion of Management Reporter Report Viewer "Versions"?

Posted on by Microsoft Employee

Hello:

Is there a maintenance plan of some sort that can be created in Management Reporter 2012 CU13 to automatically remove older versions of reports from Report Viewer?

For the first ten days of a month, we have Management Reporter's scheduled to run reports four times a day.  50% of these are Financial Detail, while the other 50% are Transaction Detail.

After being live on Management Reporter for just two months, our database has grown huge.  If you'll review the URL at the end of my posting here, you'll understand more of what I'm saying.  :)

Anyway, is there a way to schedule the automatic deletion of older versions of the reports rather than manually right-clicking them in Report Viewer and choosing "Delete"? 

From what I read in the URL below, removing older versions is the only real cure.  We just need to have that task automated.

Thanks!

John

https://community.dynamics.com/gp/f/32/t/82402

*This post is locked for comments

  • Rosa Diazvela Profile Picture
    Rosa Diazvela 15 on at
    RE: Automated Deletion of Management Reporter Report Viewer "Versions"?

    Hi John,

    This is Rosa Diazvela at Davis Technical College. Can you send me the script to delete the older versions of the reports generated in Management Reporter please?  We run a lot a reports and I need to delete them manually.

    Thank you!

    Rosa Diazvela

    Accountant

    Davis Technical College

    My email is. rosa.diazvela@davistech.edu

  • Rosa Diazvela Profile Picture
    Rosa Diazvela 15 on at
    RE: Automated Deletion of Management Reporter Report Viewer "Versions"?

    Hi John,

    This is Rosa Diazvela at Davis Technical College. Can you send me the script to delete the older versions of the reports generated in Management Reporter please?  We run a lot a reports and I need to delete them manually.

    Thank you!

    Rosa Diazvela

    Accountant

    Davis Technical College

    My email is. rosa.diazvela@davistech.edu

  • RogerRogerATX Profile Picture
    RogerRogerATX 1,515 on at
    RE: Automated Deletion of Management Reporter Report Viewer "Versions"?

    >Knowing that Microsoft stopped to do any further development on the MR product doesn't sound very positive neither

    I know what you mean!

  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Automated Deletion of Management Reporter Report Viewer "Versions"?

    Hi Roger,

    Microsoft had replied in the Connect suggestion that they did put the request in their list for future improvements.. however, that doesn't give us any kind of release expectation :-).

    connect.microsoft.com/.../1958051

    Knowing that Microsoft stopped to do any further development on the MR product doesn't sound very positive neither, since the announcement of the partnership with JetReports to deliver JetExpress for free with future GP versions.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Automated Deletion of Management Reporter Report Viewer "Versions"?

    I apologize, Beat.  And, thanks, for refreshing my memory!  I haven't kept up with that thread, since we had to dump the Data Mart due to its generating inaccurate figures.

    Thanks!

    John

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Automated Deletion of Management Reporter Report Viewer "Versions"?

    Hi John,

    I know how the thread started about rebuilding the DM.. but the discussion evolved around how to clean-up the MR database from old reports.. thus the reason why I said, keep reading down the thread.

    We too use only the Legacy connector and this script works perfectly.

  • RogerRogerATX Profile Picture
    RogerRogerATX 1,515 on at
    RE: Automated Deletion of Management Reporter Report Viewer "Versions"?

    Beat, did MS acknowledge the request on Connect for a future version?

    (I know this is a pain, our MR db had grown to over 200gb earlier this year, we got it purged though)

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Automated Deletion of Management Reporter Report Viewer "Versions"?

    Hi Beat:

    We're not on the Data Mart.  We're using the Legacy Adapter.  The thread that I started that you're referring to regards the Data Mart database.

    John

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Automated Deletion of Management Reporter Report Viewer "Versions"?

    Hi John,

    The following thread (that was started by you :-) ) has all what you need to run a scheduled clean-up of the MR 2012 database.. The thread is fairly long, but follow the trail and you'll figure out.

    community.dynamics.com/.../189997

    PS: if you run on CU11 or up, you have to adjust the script content to fit the proper naming of the new table schema owner (not dbo anymore for all the tables like up to CU10).

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Automated Deletion of Management Reporter Report Viewer "Versions"?

    Thanks, Roger!  I understand.  I'll discuss with you, offline.  :)

    John

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,188 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans