Friday, March 30, 2012

rsinvaliddataSourceReference problem

Hi,
I have some rdl files to be deployed using RS 2005. I have 3 folders viz., ReportFolder1, ReportFolder2 and System Files.
ReportFolder1 - contains soem reports
ReportFolder2 - contains some other types of reports
System Files - Contains the shared Data source
All the above folders are present in a main folder called ReportMain
In all my rdl files I have given the value of DataSourceReference element as 'ReportMain/System Files/MyDatabase'.
Still when the reports are deployed and i try to view any report, I get the following error:
The report server cannot process the report. The data source connection information has been deleted.(rsInvalidDataSourceReference).

Why do I get this error still? Can anyoen help?
Thanks.

Hi SandyJ,

This is because ur not pointing the reports to the required data source

I am giving u step by step solution for this issue.

1. go to Report Manager(http://<servername>/reports/pages/Folder.aspx)

2. Click on the Folder in which u have reports

3. U will be directed into contents tab where u will find Show Details at the right top corner

4. Click on Show Details

5. Check in the particular report and click the edit button corresponding to it

6. Go to the properties tab and click on it

7. U will find a menu on left hand side, click on Data Sources link

8. There u will find radio button selected for A share data source(by default) and a browse button.

9. Click on the browse button u will find the tree structure of the datasource and the reports folder.

10. select the datasource in the datasource folder and select OK.

by this way u will be able to point the report to the datasource.

Regards,

Vamsi Krishna Korasiga

No comments:

Post a Comment