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 studio.net 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
http://lqqsql.wordpress.com
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