Solved

Error when adding existing VS2003 report file (.rdl) into CRM 4.0 projects

Posted on 2008-10-14
3
1,424 Views
Last Modified: 2012-05-05
Hii,

I am working on Report module in my Dynamics CRM 4.0.

I have already had a VS2003 report (.rdl file) for my Dynamics CRM 3.0. Therefore, in order to use this report in Dynamics CRM 4.0, I have already converted the .rdl report using VS2005, unchecked the Shared Data source, had the correct SRS Server Name and database, and also used WIndows Authentication.

I can see that the new report can be viewed in "http://localhost/reports"

I have also already set the security role assignment to Microsoft CRM Publisher.

Steps to produce:
1. Add New Report
2. In Report Type, I have selected "Add Existing File" and I have browsed the file from my local system .rdl file which worked well in SSRS
3. I have clicked on OK
4. Error has occurred as above.

I have already set the DevError = ON, but I still could not see details of the error.

I tried to download original reports, eg:"User Summary/Account Summary" from CRM 4.0 and then upload them again, the error as above also occurred.

I also have tried to create a report using Report Wizard, another error come out:

Server Error in '/' APplication.
The request failed with HTTP staus 403: Forbidden.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Net.WebException: The request failed with HTTP status 403: Forbidden.

Is there experts here can help me to solve this problem?? I'm just a newbie to this Dynamics CRM. Thanks in advance.

Cheers,
0
Comment
Question by:johnstockbridge
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 15

Expert Comment

by:WilyGuy
ID: 22727077
Where were you performing the action? (On the CRM server, on the SRS server into the CRM Server, on a client workstation)
Who were you logged in as and what security role in CRM does that user have? (System Administrator, System Customizer, Salesperson, Custom Role, etc)

The other canned reports work in CRM currently?  SRS on the CRM or separate server?  SRS Data Connector installed?

Lets focus on the import using CRM, rather than directly to SRS as MSFT is moving away from direct SQL or SRS Access.

I was able to export the User Summary and Re-Import and run it.  I changed the name so that I could see both reports and both work.
0
 
LVL 15

Expert Comment

by:WilyGuy
ID: 22782387
Haven't heard any update, so I'll add some more stuff.

Where are SRS and CRM?  Same server or different?

Can you create a new report using the wizard in CRM?
You can download the CRMDiagTool from http://blogs.msdn.com/benlec look for the download link on the right and in the list download the crmdiag4 tool.  When you run that on the CRM server, you can toggle the DEV errors (which don't appear to be helping) as well a turning on Tracing which will give you a lot of information in a short time.

If you can upload reports to SRS, but not to CRM, I wonder if the rights were set correctly during install or if something has changed (service accounts, etc.) since then?
0
 

Accepted Solution

by:
johnstockbridge earned 0 total points
ID: 22782625
Sorry for delayed reply.

Anyway, I have fixed it by myself.
The problem is I specified wrong SRS url in CRM Deployment Manager.
After I put the correct SRS url, I can import the (.rdl) report file.

Thanks a lot for your helps.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question