Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Management Report Designer Issue -- Not able to display the Report designer window

Posted on by 5

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

Categories:
  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Management Report Designer Issue -- Not able to display the Report designer window

    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 AccountStatus
    FROM Reporting.SecurityUser A
    JOIN Reporting.SecurityPrincipal B ON A.USERID = B.ID
    ORDER BY A.UserName

  • Greg Byer Profile Picture
    Greg Byer 2,586 on at
    RE: Management Report Designer Issue -- Not able to display the Report designer window

    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.  

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans