Solved

Accidentally deleted CRM report folder in SQL report manager

Posted on 2007-11-21
10
734 Views
Last Modified: 2013-11-24
I accidentally, deleted the CRM Reports folder in the Report manager (https://<servername>/reports) off course now we do not have any reports in the CRM. I tried to create a folder in there called MSCRM and uploaded all the reports in there but they still are not visible in the CRM.

help pls
0
Comment
Question by:Biju708
  • 5
  • 5
10 Comments
 
LVL 8

Expert Comment

by:rfgkev
Comment Utility
they wont be visible, the internal id's in the report database will have changed.

try uploading the reports through the report interface in crm.
0
 

Author Comment

by:Biju708
Comment Utility
tried it but it is giving me an error. and an option to try again, but it always ends up in an error.
0
 
LVL 8

Expert Comment

by:rfgkev
Comment Utility
do the deleted reports still show up in CRM? if so try removing one of the and re-uploading it.
0
 

Author Comment

by:Biju708
Comment Utility
what I did was create a folder on the report server upload the crm report from the crm cd and then change the connection string to read from the CRM Database. This works if you log in to https://<companyname>/reports however it's not available if you try to run the report from the CRM
0
 
LVL 8

Expert Comment

by:rfgkev
Comment Utility
they need to be uploaded via crm so it can grab the report server's id for them. if you look in the crm database, find the table that stores the report data. you'll have to change the report server ID's to those of the reports in the report server database.

Alternatively, and probably much easier, chear out the reports table then upload them through crm.
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 

Author Comment

by:Biju708
Comment Utility
I had a look for the tables but I could not find the reports table, now how strange is that ? maybe CRM just reads data from the Reportserver database
0
 
LVL 8

Expert Comment

by:rfgkev
Comment Utility
it definetly keeps it somewhere cause of the description you can add and the entity linking and stuff like that. unfortunately i dont have a crm system accessible at the moment so i can't have a better look at it. sorry.
0
 

Author Comment

by:Biju708
Comment Utility
thanks , rfgkev. if you have a look at your system maybe you can tell me what is the folder called inside the report server http://<yourcompanyname>/reports

thanks
0
 
LVL 8

Accepted Solution

by:
rfgkev earned 500 total points
Comment Utility
if i remember correctly its <yourcompanyname>_MSCRM
0
 

Author Comment

by:Biju708
Comment Utility
Great rfgkev, problem is fixed. I just renamed the folder to <yourcompanyname>_MSCRM and the reports just popped up again :-)

0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Supply Chain Event Management Supply chain visibility is the ability of a company to track its products and business processes in supply chain towards building operational excellence. The goal of supply chain visibility is to improve and strength…
Salesforce.com is a cloud-based customer relationship management (CRM) system. In this article, you will learn how to add and map custom lead and contact fields to your Salesforce instance.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

762 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now