Monday, March 19, 2012

Cannot create models with data source views using the ReportingService2005 web service

Question: Using the ReportingService2005 web service, how do I create a report model with a "data source view"?

Background: We are planning on shipping SQL Server 2005 (Work Group Edition) with our Enterprise application to over 30 countries. We hope to leverage the functionality of Reporting Services from our application.

We will be referencing the ReportingService2005 web service for configuration and installation of our application reporting environment. We DO NOT have access to customer machines since this is a "shrink-wrap" application. Furthermore, the customer should NOT be required to use the Business Intellegence Studio to configure the application.

Problem: We are able to create shared data sources and reports without any problems using the ReportingService2005 web service. Furthermore, we are able to generate report models based on the share data sources without a problem. However, we are unable to generate report models with "Data Source Views" using the web service. I have tried to use the CreateModel method but when I examine the data model in Reporting Services, there is an an error stating: " The shared data source reference is no longer valid".

When you say, "I examine the data model in Reporting Services", do you mean that you download the report model file and try to open it as part of a Report Model project inside BI Development Studio?|||

No, I mean that I surf into the Reporting Services website, click on the newly created model, and then click on the link labled "Data Sources". It is there that I receive the message "The shared data source reference is no longer valid."

I am then forced to browse to the newly created data source and click "apply". If I don't go through this "manual" process, I received an error when I try to create a report (using Report Builder) based on the newly created model.

No comments:

Post a Comment