I have a complex query I use to populate reports. I need to move the
reporting environment from actual production database that gets updated
frequently. I have converted the reporting query into a view that pulls
information from many tables with complex joins

In my reporting databases, i have a simple table with the exact fields
in my view.

So here is the situation.

Server A (Live production DB)
Many tables
View - V_abc (with complex joins and returns some columns)

Server B (Reporting Server)
View - V_abc (referencing T_abc with the same exact column on ServerA
view columns)
Table - T_abc (referenced by V-abc with the same column names)

I am trying to set up transactional replicatin (as I need live data) to
pull information from the Production Server A view and insert it into
the  reporting Server B db view (V_abc) which will place data to the
underlaying table (T_abc).

I keep getting the error message when I start the replication
"Unable to replicate a view or function because the referenced objects
or columns are not present on the Subscriber. - (Source: AGENT (Agent);
Error number: 00000)"

Its also dropping the View in ServerB.

Is this even posible or am I just chasing ghost..???

I would appreciate some help with this problem...