Solved

Accidentally deleted CRM report folder in SQL report manager

Posted on 2007-11-21
10
738 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
[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
  • 5
  • 5
10 Comments
 
LVL 8

Expert Comment

by:rfgkev
ID: 20327558
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
ID: 20327754
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
ID: 20327864
do the deleted reports still show up in CRM? if so try removing one of the and re-uploading it.
0
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 

Author Comment

by:Biju708
ID: 20327997
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
ID: 20328166
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
 

Author Comment

by:Biju708
ID: 20328312
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
ID: 20328560
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
ID: 20328691
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
ID: 20333411
if i remember correctly its <yourcompanyname>_MSCRM
0
 

Author Comment

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

0

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

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

Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

696 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