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

RS and OLAP (Database not found)

I tried to use Analysis Services with Reporting Services and all worked fine, when I'm within the VS IDE. But when I upload the rdl to my Reporting Server and execute the report I got an exeption "database ... not found".
I have 1 server with IIS and Reporting Services and 1 server with SQL 2000 and Analysis Services installed.
I there anybody who can help me ?
Many thanks
PeterPeter,
I am having a similar problem. I have RS on one server and AS on a
different server. I have not been able to figure out how to pass the
appropriate credentials from RS to the AS server.
In your solution was RS and As on the same server?
Thanks,
Blaine
"PNeuwi" wrote:
> We solved the problem by adding roles to the OLAP-Database and using this user for the connect. We stored the user information to the report server and used it as windows credentials.
> Peter|||Blaine,
I am having the same problem. Were you able to find a solution?
"Blaine" wrote:
> Peter,
> I am having a similar problem. I have RS on one server and AS on a
> different server. I have not been able to figure out how to pass the
> appropriate credentials from RS to the AS server.
> In your solution was RS and As on the same server?
> Thanks,
> Blaine
> "PNeuwi" wrote:
> > We solved the problem by adding roles to the OLAP-Database and using this user for the connect. We stored the user information to the report server and used it as windows credentials.
> >
> > Peter|||Did you find a solution? I read another article that said something about
setting SSPI=Kerberos on the datasource.
Steve
"George Kousis" wrote:
> Blaine,
> I am having the same problem. Were you able to find a solution?
> "Blaine" wrote:
> > Peter,
> >
> > I am having a similar problem. I have RS on one server and AS on a
> > different server. I have not been able to figure out how to pass the
> > appropriate credentials from RS to the AS server.
> > In your solution was RS and As on the same server?
> >
> > Thanks,
> >
> > Blaine
> >
> > "PNeuwi" wrote:
> >
> > > We solved the problem by adding roles to the OLAP-Database and using this user for the connect. We stored the user information to the report server and used it as windows credentials.
> > >
> > > Peter