Detail Report does not run in SSRS
I have one report that contains a sub report that shows detail. When I run the reports in visual 2005, they both run perfectly as expected, but when I run them on report manager, which is ssrs 2008, the main report runs perfectly, but when I try to click on the details, I get the following error: The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference) Both the main report and the detail one are using the same data source. I have gone as far as deleting the detail report and readding it to report manager, but get the same error. Help! Any ideas?DBA
October 21st, 2010 10:29pm

Hi, Can you connect to the sub report directly - and then click on properties. From there click on data sources and browse to the source you want to use. Although they are using the same source they may have gone out of sync at some point - and the sub report is looking for a data source with the same name but a different GUID Seth
Free Windows Admin Tool Kit Click here and download it now
October 22nd, 2010 4:25pm

Both reports, like I said work perfectly in Visual Studio, but when I bring to report manager just the main report works and not when I click on the detail section. BTW, the detail section does not run on its own and is dependant on the main report, and this is by design. Now before we upgrade to 2008 from 2005 (and before I modified the detail section) the reports worked fine. It was only after migrating that they failed to work. Could this be the cause?DBA
October 22nd, 2010 8:34pm

Figured it out, It appears that I need to delete and reupload the report again to workDBA
Free Windows Admin Tool Kit Click here and download it now
October 22nd, 2010 9:54pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics