Reporting Service CRM Error in http.

Tamur Aziz 1 Reputation point
2022-09-26T09:13:41.46+00:00

Error. the item '/KomMedCRMDev/Member' cannot be found. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/KomMedCRMDev/Member' cannot be found. (http://SKAFUTVAPPCRM09.ad.Commun.se:2011/CWPKMW/API/Report/Member).
Status: 500 (Internal Server Error).

Repport is working in CRM, SSMS and In Reporting services but when I try to access the list from http link then when I select this specific report with the reports then above mentioned error come.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,808 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,813 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,566 Reputation points
    2022-09-27T03:47:15.747+00:00

    Hi @Tamur Aziz ,
    Could you access the report server using the address you used in the install process. e.g http://yourServer/reportserver; if in Reporting Services SharePoint mode, to add a .rdl report to web part, we need to specify URL with fully qualified path to a report and the .rdl file extension must be included.

    The SQL Reporting Services Report Viewer is an ASP.Net control which runs on the CRM 4.0 Web server. In CRM 3.0, and when you interact with the SSRS Report Manager, that control is running on the Web server fronting SSRS. When you choose to run a report from CRM 4.0 the ASP.Net control requests the report and data from the remote SSRS box. In practical terms: in CRM 3.0 the URL for a report was the URL for the SSRS Web server; in CRM 4.0 the URL for a report is the CRM Web server.

    You also need to ensure that you properly handle the security of your CRM and SSRS integration.

    For more information, please refer to: How it Works: SQL Server Reporting Services and Dynamics CRM.
    Best Regards,
    Joy

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments