SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Subreport issue uploaded to Sharepoint 2010		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

cidr
Posting Yak Master

United Kingdom
192 Posts
Posted - 10/09/2012 :  15:05:10  Show Profile  Reply with Quote
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

India
47189 Posts
Posted - 10/09/2012 :  23:11:15  Show Profile  Reply with Quote
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

United Kingdom
192 Posts
Posted - 10/10/2012 :  12:36:58  Show Profile  Reply with Quote
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

India
47189 Posts
Posted - 10/11/2012 :  00:30:27  Show Profile  Reply with Quote
ok cool

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

cidr
Posting Yak Master

United Kingdom
192 Posts
Posted - 10/11/2012 :  05:14:51  Show Profile  Reply with Quote
I mean, I still have the problem

Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
47189 Posts
Posted - 10/11/2012 :  15:27:29  Show Profile  Reply with Quote
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

United Kingdom
192 Posts
Posted - 10/11/2012 :  17:45:37  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000