{"id":6610,"date":"2014-04-20T13:46:00","date_gmt":"2014-04-20T13:46:00","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2014\/04\/20\/ssrs-in-native-mode-with-sharepoint-data-source-collection-of-common-programming-errors\/"},"modified":"2014-04-20T13:46:00","modified_gmt":"2014-04-20T13:46:00","slug":"ssrs-in-native-mode-with-sharepoint-data-source-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2014\/04\/20\/ssrs-in-native-mode-with-sharepoint-data-source-collection-of-common-programming-errors\/","title":{"rendered":"SSRS in Native mode with SharePoint data source-Collection of common programming errors"},"content":{"rendered":"<p>Hi Ninsr,<\/p>\n<p>Thanks for posting your question here. Based on my research, it seems like this issue caused by the Catching Shared Datasets.<\/p>\n<p>I guess that when you create the dataset in BIDS, the datasource helps you locate to the exact position of the list (such as http:\/\/intranet.mycompany.local\/it). Actually, after first run, the results and the correct server URL has been cached. And then if you change the connection string, the report still displays the correct result when you preview it.<\/p>\n<p>However, after you deploy the report to reportserver, when the report first run, it will get the data based upon the datasource and dataset again. If the connect string is not\u00a0locate to the exact position of the list,\u00a0you will meet this error, so please ensure that the\u00a0connection string can locate to the exact position of the list.<\/p>\n<p>Hope it helps you. For more information, please refer to:\u00a0 Caching Shared Datasets (SSRS)<\/p>\n<p>Regards,<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi Ninsr, Thanks for posting your question here. Based on my research, it seems like this issue caused by the Catching Shared Datasets. I guess that when you create the dataset in BIDS, the datasource helps you locate to the exact position of the list (such as http:\/\/intranet.mycompany.local\/it). Actually, after first run, the results and [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-6610","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/6610","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=6610"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/6610\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=6610"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=6610"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=6610"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}