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

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

RS2005 Report Question

Can I place the same report in two folders, but only have one report in the
SQL database? So I only have to upload one.Read up on linked reports.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"gdjoshua" <gdjoshua@.discussions.microsoft.com> wrote in message
news:A3C42565-232E-416E-845E-19708199B868@.microsoft.com...
> Can I place the same report in two folders, but only have one report in
> the
> SQL database? So I only have to upload one.|||Thanks again Bruce...... I can't believe its that easy...
Joshua
"Bruce L-C [MVP]" wrote:
> Read up on linked reports.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "gdjoshua" <gdjoshua@.discussions.microsoft.com> wrote in message
> news:A3C42565-232E-416E-845E-19708199B868@.microsoft.com...
> > Can I place the same report in two folders, but only have one report in
> > the
> > SQL database? So I only have to upload one.
>
>

RS.exe Scripter DataSource error

Is it possible within an .rss script to set the data source of a report?
In other words I created an .rss script that generates all the folders and creates and uploads all the reports and data sources to Reporting Services. The problem is that I have to then go in and manually point each report to the right data source. I would like to automate this task too within the .rss script.

Learnthis is the sample i used to attach the datasource but it still does not work:

Dim fullpath As String = SubFolderPath + "/Report.rdl"
Dim dataSources(0) As DataSource
Dim dsr0 As New DataSourceReference
dsr0.Reference = "/Mydir/Test/mydatasourcename"
Dim ds0 As New DataSource
ds0.Item = CType(dsr0, DataSourceDefinitionOrReference)
ds0.Name="mydatasourcename"
dataSources(0) = ds0
rs.SetItemDataSources(fullpath, dataSources)i

The error I keep getting when i click the report I just published is:

"The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)"

And the error I get from the cmd is :

"Unhandled exception:
The data source 'cdo_suite_5_qa' cannot be found."


Any advice would be very helpful.
Steve

The fullpath does not need the .rdl extension but only the path and name of the report.

You could also try rs.SetReportDataSources rather then rs.SetItemDataSources.

RS.exe Scripter DataSource error

Is it possible within an .rss script to set the data source of a report?
In other words I created an .rss script that generates all the folders and creates and uploads all the reports and data sources to Reporting Services. The problem is that I have to then go in and manually point each report to the right data source. I would like to automate this task too within the .rss script.

Learnthis is the sample i used to attach the datasource but it still does not work:

Dim fullpath As String = SubFolderPath + "/Report.rdl"
Dim dataSources(0) As DataSource
Dim dsr0 As New DataSourceReference
dsr0.Reference = "/Mydir/Test/mydatasourcename"
Dim ds0 As New DataSource
ds0.Item = CType(dsr0, DataSourceDefinitionOrReference)
ds0.Name="mydatasourcename"
dataSources(0) = ds0
rs.SetItemDataSources(fullpath, dataSources)i

The error I keep getting when i click the report I just published is:

"The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)"

And the error I get from the cmd is :

"Unhandled exception:
The data source 'cdo_suite_5_qa' cannot be found."


Any advice would be very helpful.
Steve

The fullpath does not need the .rdl extension but only the path and name of the report.

You could also try rs.SetReportDataSources rather then rs.SetItemDataSources.