Accidentally deleted CRM report folder in SQL report manager

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.

tried it but it is giving me an error. and an option to try again, but it always ends up in an error.

do the deleted reports still show up in CRM? if so try removing one of the and re-uploading it.

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

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.

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

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.

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

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