Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Issues in GetItemDataSources web service call

Author  Topic 

singhalkul
Starting Member

1 Post

Posted - 2010-09-06 : 05:48:35
Hi,

I'm using Reporting Services web services endpoint ReportService2005.asmx with 2008 report server R2 and I'm facing some issues in getting the data source names for a report definition using the GetItemDataSources web service. The problem is that the data source names returned are different from the names of the actual data sources on the report server.

The report has the following data sources:

1. 0
2. 1
3. _0
4. _A
5. Data Source

And the names returned by the GetItemDataSources for 2008 report server R2 is:

1. AutoGen_0
2. AutoGen_1
3. AutoGen__0
4. AutoGen__A
5. Data_Source

When I make the same calls using a 2005 report server, the names returned are the same as that in the report definition.

To summarize, only numeric data source names are changed to "Autogen_<number>"(eg. Autogen_0), data source names beginning with "_" are changed to "Autogen_<data source name>"(eg. AutoGen__A) and spaces are replaced by an "_".



What is the problem for the data source names returned for 2008 report server R2? Or has there been any change in the way in which report server stores the data source names?

Thanks,
Kulbhushan Singhal.
   

- Advertisement -