Uploading a Report File to CRM (.rdl) throws "rsInvalidDataSourceReference Error"

(0) Share

Report

Posted on by Community Member

Hello everyone,

We created an sql stored procedure that returns a custom report in our sql. The stored procedure was added to a Report Data Set in Visual Studio 08, because we were unable to add it to VS 2013 and 2010.

When I try to add the .rdl file that was created in the VS08, to the Report Section in my Solution - I get this error "rsInvalidDataSourceReference Error".

Is this error thrown because of the Visual Studio version that created the file, or is it something else? Is there a way to create an .rdl file from sql stored procedure in Visual Studio 2013, because I can't seem to find it.

I tried using the Report Application and then add my database to it, but there wasn't a reference to the stored procedure.

Thanks in advance,

Georgi B.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

NKC on at

Like (0)

Report

Hi

Please restart the reporting services and try again. Thanks

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I restarted the services from the RSConfiguration Manager, but the outcome is still the same. I can't add the stored procedure to VS 2013.

Was this reply helpful? Yes No
NKC on at

Like (0)

Report

Hi

Never used vs2013 but used 2008 for CRM2011 and 2013 i never had a problem to upload reports. I come across same error last week when i tried to run the reports and upload, after restarting the reporting services on the server it worked fine for me. What about other reports r u able run other reports in CRM?

Was this reply helpful? Yes No
account payable 670 on at

Like (0)

Report

Dear

I got the same error when i upload rdl file of report showing "error uploading report " please find below screenshot file .

Am using crm On-premise 2013 .i could upload in test crm but when i upload in live showing like below screenshot file and also other reports also not working (in live crm ) when i run report showing like "Report error while getting the data source contents for the report

error detail:error occurred while getting the data source contents " .In test crm report is oke but problem is in live crm .am trying to upload report in crm but i cant have any solution please help if someone know about this

Was this reply helpful? Yes No
gupta.ambar2009@gma... 797 on at

Like (0)

Report

Hi,

Please cross check once by preview report from bids if there is any error .since some due to error in report its not allowed to upload .

and if there is no error then create a copy of RDL file and rename that and then try to upload new file .

Was this reply helpful? Yes No
account payable 670 on at

Like (0)

Report

Dear Ambar

There is no error while check preview in bids am just tryied upload after rename but still showing same error .please find below original my rdl file

Was this reply helpful? Yes No
JackalD365 130 on at

Like (0)

Report

Hi Sabih. What was the solution to this in the end?

Thanks

Was this reply helpful? Yes No