SELECT D.Name
,'Using Report ' = CASE
WHEN D.Name IS NOT NULL THEN C.Name
ELSE 'DataSource'
END
FROM DataSource D
JOIN Catalog C
ON D.ItemID = C.ItemID
Scenario/Steps
1)Create report in development environment, with datasource DEVDS as shared data source
2) Run above script it return the datasource as DEVDS
3)Upload report into production environment report server,
4)Run above script it return the datasource as DEVDS
5)Change the datesource to PRDDS
6)Run above script it return the datesource as DEVDS
WHY did it not return the PRDDS for the last step?
Thank you