Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Subreport issue uploaded to Sharepoint 2010

Author  Topic 

cidr
Posting Yak Master

207 Posts

Posted - 2012-10-09 : 15:05:10
Hi there,

I was hoping someone could help.

I have a report that has been uploaded to a Reporting Services Document Library within SharePoint 2010. The report has a subreport and I am receiving an error in the subreport section of the report


Data retrieval failed for the subreport, 'subreport1', located at: http://URLAddress/ReportName.rdl. Please check the log files for more information.


This is part of the Sharepoint Error message:

GetNewsByNumber(IndicatorValues,25) - Microsoft.SharePoint.SPException: List does not exist.

The page you selected contains a list that does not exist. It may have been deleted by another user...


I'm sure this is to do with the subreport within the Parent report. The subreport is already within the Report Library list.

Is there something I have to do with the report/dataset to get the subreport working?

Any help is much appreciated.

Cheers

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-10-09 : 23:11:15
did you check if subreport is diplaying data correctly when report is run from BIDS?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

cidr
Posting Yak Master

207 Posts

Posted - 2012-10-10 : 12:36:58
quote:

Visakh 10/10/2012
did you check if subreport is diplaying data correctly when report is run from BIDS?



Hi visakh,

Yeah, the report works fine. I've uploaded it to a SharePoint Development site and it's fine. The problem has been at a client site.

Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-10-11 : 00:30:27
ok cool

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

cidr
Posting Yak Master

207 Posts

Posted - 2012-10-11 : 05:14:51
I mean, I still have the problem

Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-10-11 : 15:27:29
quote:
Originally posted by cidr

I mean, I still have the problem




Oh
Is the client behind a proxy? what authentication they're using?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

cidr
Posting Yak Master

207 Posts

Posted - 2012-10-11 : 17:45:37
Hi visakh,

The problem seems to have been fixed. I think it was because only a new copy of the Parent report was uploaded to the list. The subreport would have been on the list but maybe it was a glitch.

Thanks for the help:)
Go to Top of Page
   

- Advertisement -