[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 703
  • Last Modified:

Unable to run CRM 4 report - Access is Denied

CRM 4 on Server 2008 platform sitting in front of SQL 2005.

Normal user created a report with the report wizard.  All users are able to run the report ....however I have one user who still can't access the report (see screenshot).

Compared permissions and roles to users who CAN access the report - I don't know what I'm missing.
crm4.png
0
sknoll84
Asked:
sknoll84
  • 2
1 Solution
 
crm_infoCommented:
(1) Try giving the user the same permissions as other users (eliminate the possibility that it is NOT related to CRM Security Roles).
(2) Check to see that the user has reporting permissions as well as permissions to all entities that are included in the report (i.e. activities, custom entities, etc).
(3) You can turn on detailed error reporting (in the web.config, search for "error" and you'll see the setting).  Turn that on and look at the detailed error report to see if that gives you any additional information.
0
 
sknoll84Author Commented:
i can see a ton of reports under My Workplace>Reports however this user in question can not see any reports......which must be related to the problem in question.

where do i go to check reporting permissions?
0
 
crm_infoCommented:
You would check this under Security Roles.
First of all, check to see which Role(s) the user has.  If the user has more than 1 role, then choose the role that should definately include reporting provilidges.  Now go to:
Settings > Administration > Security Roles > Double Click on the Role
Go to the Core Records tab
About 3/4  of th eway down the list is a Report privilidge - make sure that the user has full Read privilidges (solid green dot).  You may want to give them other report permissions as well.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now