The report server cannot process the report or shared dataset
If you are using a report server, then perform the following steps:
- Be sure you're on a version of IE this will not work correctly in Chrome
- Go to your report server
- Click on ... , on top-right of your report name
- Click on 'Manage'
- Click on 'Data Sources'
- Make sure that Connect to: settings are pointing to the right places.
You would be amazed how many times this will happen because of a credentials issue or how the data source is setup. In the same case share data source will be in a different folder than the initial one. Maybe you will see a warning label.
Without more information about what kind of server you are using, this is all I can think of suggesting.
I Tried this Solution :-
Deploy All Data Sources and reports to report server once again.
This solution solve my problem
I was able to bulk update and fix the problem by updating the data source link using the T-SQL below.
begin tran
update dbo.DataSource
set Link = c.ItemID
from dbo.DataSource ds
inner join dbo.Catalog c
on ds.Name = c.Name
and c.Type = 5
where ds.link is null
select ds.Link oldlink, c.ItemID
from dbo.DataSource ds
inner join dbo.Catalog c
on ds.Name = c.Name
and c.Type = 5
--where ds.link is null
select *
from dbo.DataSource ds
where ds.link is null
rollback tran
-- commit tran
http://tsqlblog.blogspot.co.uk/2011/05/rsinvaliddatasourcereference-on.html