Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Deleting modified reports using SQL

Posted on by Microsoft Employee

Where are all the modified reports stored (in which table)? I have more than 50 of them and I need to get rid of all of them. Deleting one by one from the report writer window, is time consuming. Any help will be highly appreciated.

*This post is locked for comments

  • Suggested answer
    coquisalsa Profile Picture
    coquisalsa 2,725 on at
    RE: Deleting modified reports using SQL

    Modified reports are not stored in a SQL table(s), instead they are stored in dictionary files (.DIC).

    Each Dynamics GP product has its own dictionary file, e.g.:

    Modified reports for 'Microsoft Dynamics GP' are stored in REPORTS.DIC.

    Modified reports for Field Service are stored in RPTS949.DIC.

    A typical location for these .DIC files:

    C:\Program Files (x86)\Microsoft Dynamics\GP2015\Data\

    You can find the exact path for all Modified Reports and Modified Forms dictionaries in the Dynamics.set file (you can open it using Notepad).

    As callen suggest, if the Modified Reports you want to delete are part of 'Microsoft Dynamics GP' you will need to delete the REPORTS.DIC file or even better rename it.

    If the Modified Reports are part of 'Field Service' you will need to delete or rename the RPTS949.DIC file.

    I hope this help.

  • callen Profile Picture
    callen 4,595 on at
    RE: Deleting modified reports using SQL

    The easiest way would be to

    1. Change the Alternate/Modified Forms and Reports to point to the original report

    2. Delete the reports.dic and any other report dictionary files

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans