web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Missing SSRS Reports
Microsoft Dynamics AX (Archived)

Missing SSRS Reports

(0) ShareShare
ReportReport
Posted on by Owen Morehart 160

Cannot access installed SSRS reports (those AX reports marked with an asterisk).

Error reads something like this:

SRSReportView error id 3: Cannot find report sysSecurity.UserpermissionsReport.autodesign on the server under the path /Dynamics.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Have you deployed the reports?

  • Owen Morehart Profile Picture
    Owen Morehart 160 on at

    What should I be looking for?  Looking in the install folder (where the software from our implementation team was loaded) I don't see anything that sticks out as SSRS reports.

  • Community Member Profile Picture
    Community Member on at

    Well,

    you will first have to install reporting extensions, at the end of the installation it will give you an option to deploy the reports. You can use that to deploy the reports on the server.

  • Owen Morehart Profile Picture
    Owen Morehart 160 on at

    Extensions have been installed.  However, when deploying the reports the process blows up.  Error log below...

    Could not load file or assembly 'Microsoft.Dynamics.AnalysisServices, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.   at System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)

      at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)

      at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)

      at System.AppDomain.Load(String assemblyString)

  • Lance [MSFT] Profile Picture
    Lance [MSFT] on at

    Microsoft.Dynamics.AnalysisServices sounds like a file from the AX Analysis Extensions component.  You could try installing that first.

    One more thought ... If you deploy a few reports at a time, it might be possible to avoid the report that triggers the error.  

  • Suggested answer
    Mehul Thacker Profile Picture
    Mehul Thacker 165 on at

    Hi Lance,

    There may be one case that version of your .Net BC and\or Reporting extension component is different than the version of Installed AOS + Application file + .net BC installed on AOS Computer.

    All in all,

    It could be case of VERSION mismatch between Component installed.

    Thank & Regards,

    Mehul Thacker

  • Community Member Profile Picture
    Community Member on at

    I faced the same issue while using report server 2005 but I solved it by correcting the report server url in the report server config file, the problem is that I modified the server name long time ago but didn't change this url, please review the steps from the "Microsoft Dynamics AX 2009 Installation Guide".

    If you are using Reporting Services 2005, use the following procedure to update the configuration file.

    1. Open the rsreportserver.config file. By default, this file is located in \Program Files\Microsoft SQL  Server\ReportingServicesInstance\Reporting Services\ReportServer.

    2. Locate the UrlRoot XML element and update the URL in that element, if necessary.

    <UrlRoot>https://ServerName:PortNumber/reportserver</UrlRoot>

    3. Save your changes and close the file.

    4. Make a backup of the rsreportserver.config file.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans