I am not able to open the Report designer window on my Report Designer
I will show only the security option with User, Group and Company
I am the user as Administrator
Are you logged into a company? The company ID will appear in the bottom of the MR Report Designer window, to the left of your domain\username. You can also try clicking Company | Companies, then select a company and click Set as Default. Once you are logged into a company, you should see Report Definition, Row Definition, Column Definition, Reporting Tree Definition, Report Group, and Report Schedules on the left side navigation bar.
Can you run this SQL query in SSMS against your MR database ? Check if your user name & Windows ID comes up and is labeled as an Administrator.
SELECT A.UserName , B.NAME , CASE A.ROLETYPE WHEN 2 THEN 'VIEWER' WHEN 3 THEN 'GENERATOR' WHEN 4 THEN 'DESIGNER' WHEN 5 THEN 'ADMINISTRATOR' END AS SecurityRole, A.WindowsSecurityIdentifier , A.UserID , CASE A.AccountDisabled WHEN 0 THEN 'Enabled' WHEN 1 THEN 'Disabled' END AS AccountStatusFROM Reporting.SecurityUser AJOIN Reporting.SecurityPrincipal B ON A.USERID = B.IDORDER BY A.UserName
SELECT A.UserName
, B.NAME
, CASE A.ROLETYPE WHEN 2 THEN 'VIEWER'
WHEN 3 THEN 'GENERATOR'
WHEN 4 THEN 'DESIGNER'
WHEN 5 THEN 'ADMINISTRATOR' END AS SecurityRole
, A.WindowsSecurityIdentifier
, A.UserID
, CASE A.AccountDisabled WHEN 0 THEN 'Enabled'
WHEN 1 THEN 'Disabled' END AS AccountStatus
FROM Reporting.SecurityUser A
JOIN Reporting.SecurityPrincipal B ON A.USERID = B.ID
ORDER BY A.UserName
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,029
André Arnaud de Cal... 871 Super User 2025 Season 2
Sohaib Cheema 582 User Group Leader
