Go to the Admin area and remove all roles from anyone who cannot access the reports. Then add the roles back until you are satisfied with the rights that you have assigned.
I actually don't have any roles created. I tried creating a role, and I got the following error:
Cannot insert the value NULL into column 'ACTION_ID', table 'SplendidCRM.dbo.ACL_ROLES_ACTIONS'; column does not allow nulls. INSERT fails. The statement has been terminated.
Another odd thing I noticed is that if I search role by user, "Reports" is not even listed in the options.
What version of SplendidCRM are you running? Has your database been updated to match the version of the web application?
What customizations have you made? Have you added any modules?
I'm using SplendidCRM Community Version 4.4.3855.40423 (SugarCRM Version 4.5.0)
This is what I had installed initially, and I re-ran the database script. While modifying, I had run into other issues that rerunning Setup.exe in the sql server express folder had fixed before, but this time it didn't help.
I have added several new modules, but I don't remember doing anything to the ACL_Roles table. If I do: * from vwMODULES_TabMenu
the Reports module shows up, and so do the new modules I have added. However when I do: * from vwMODULES_TabMenu_byUser
The reoprts module doesn't show up. There are no entries in the ACL_Roles tables.
We don't support reports on the Community edition. Is this a module that you created? The issue must be that the module was not completely defined.
Copyright (c) 2006-2012 SplendidCRM Software, Inc. All Rights Reserved.