Friday, March 23, 2012

Report Model/Datasource View, Primary Data Source Problem

I have a datasource view DSV1. It points to a datasource DS1 that is considered the "primary".

I have created a Report Model that uses DSV1 (and thus uses DS1)

I created a new datasource, DS2 that I would like to use instead of DS1. (I can't just modify DS1 because if I modify it, it will overwrite it when we go to our Production environment and break that datasource)

So, I can go into DSV1 and change all the references from DS1 to DS2.

But that's where the problem lies.

When I try to build, I get the following error:

"The Table property of the Entity "E1" refers to the Table "dbo_View", which is not in the primary data source."

Somehow, the entity is tied to the "primary" datasource. When I change it back to DS1, everything works fine. Any thoughts? What can I do?

Here is what I've noticed:

If I look at the code for the Data Source DS1, the XML shows an <ID> tag and a <NAME> tag.

In SSRS, it is requiring that the ID be named "DS1", but the name can be whatever I want.

So if I change the name, it looks like I can deploy no problem without overwriting my old Datasource, but I just wish I could have these two pieces updated without a problem.

Any idea why this is?

No comments:

Post a Comment