Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Error when running cus...
Microsoft Dynamics GP (Archived)

Error when running custom reports: Error Accessing SQL Data

(0) ShareShare
ReportReport
Posted on by kuroneko1313 2,119

Hello,

We just upgraded to GP 10.0 from version 9.0. Today our users encountered an error when running custom report for Historical Orders. Custom report for Open Orders can be ran just fine.

However when I try to run the Historical Orders custom report using SA login, I can run it just fine. Could this be a permission issue? If yes, how to modify it in the reports?

I tried re-importing the reports to each user but that didn't help. I also deleted the REPORTS.DIC file and re-imported, and didn't help either.

Could someone please help me on this issue? Thanks in advanced for your help!

 

-Elizabeth

 

*This post is locked for comments

  • kuroneko1313 Profile Picture
    kuroneko1313 2,119 on at
    Re: Re: Error when running custom reports: Error Accessing SQL Data

    Richard, thank you and sorry for the late reply.

    Yes for some reason certain User Security works on the Custom History report, while others don't. I'm trying to find the difference between these User Securities (I don't think there's any though).

    Thank you very much for your help in this!

     

    -Elizabeth K.

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: Error when running custom reports: Error Accessing SQL Data

    Version 10 has a completely different security system from V9.  Your statement that sa can run the reports leads me to think that it is a security issue.

    Under Administration, under Setup/System, open the Alternate/Modified Forms and Reports.  This defines groups of permissions that can be assigned to users.  If you converted security, you may have one group for each original user.  Most firms use the DEFAULTUSER group for everyone.  Only one of those, the DEFAULTUSER or the user specific group may need to be edited to include the report.

    Pick a user and look under User Security and see which Alternate/Modified Forms and Reports group is assigned to the user.  Open that group in the A/MFR and edit it to give the user permission to the reports. 

    Let us know what happens.

    For more information on how the V10 Security system works, you may want to get a copy of our Dynamics GP Security Handbook.  Check our web site at http://www.AccoladePublications.com and browse into the Library.

     

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans