Accidentally deleted CRM report folder in SQL report manager

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
Biju708Asked:
Who is Participating?
 
rfgkevCommented:
if i remember correctly its <yourcompanyname>_MSCRM
0
 
rfgkevCommented:
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
 
Biju708Author Commented:
tried it but it is giving me an error. and an option to try again, but it always ends up in an error.
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
rfgkevCommented:
do the deleted reports still show up in CRM? if so try removing one of the and re-uploading it.
0
 
Biju708Author Commented:
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
 
rfgkevCommented:
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
 
Biju708Author Commented:
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
 
rfgkevCommented:
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
 
Biju708Author Commented:
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
 
Biju708Author Commented:
Great rfgkev, problem is fixed. I just renamed the folder to <yourcompanyname>_MSCRM and the reports just popped up again :-)

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.