News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Security to SRS Reports

Microsoft Dynamics GP (Archived)

Security to SRS Reports

(0) Share

Report

Report

Posted on by Nancy Hogan

1,295

Customer created a report using SQL Reporting Services and is unable to see and run the report as sa. However, they have users that cannot see the report in the "Custom Reports" under Reports Shortcuts on the Administration NAV pane (where he is accessing the report as sa). Where do we give security in GP 10.0 for this report? They have already given the SRS security to every user. The only users that can see them under Custom Reports is the sa user and 1 other user.

Thanks,

Nancy

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Nancy Hogan 1,295 on at

Like (0)

Report

Re: Re: Security to SRS Reports

Thanks for the suggestions Mike. I had opened a case with MS and it turns out it may be something with their Firewall.

Nancy
Michael Marinaro 8 on at

Like (0)

Report

Re: Security to SRS Reports

Hi Nancy,

A couple of things to check:

1. Is the report published to the proper folder under the Reporting Services web site (i.e. TWO/Sales/..) If it isn't in one of the preexisting folders, it may not show up in GP.

2. Can the user run the report outside of GP. For SRS reports, the GP user is irrelavent. Make sure that your Windows user can access the report via http://servername:port/Reports

Let me know what you find.

Thanks,
Mike

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans