CR9

this morning I created a view at the server

CREATE VIEW dbo.vwDemandSupplyLinkSingleLinePerWO
AS
SELECT     ROWID, ID, DEMAND_TYPE, DEMAND_BASE_ID, DEMAND_SEQ_NO, SUPPLY_TYPE, SUPPLY_BASE_ID, SUPPLY_SUB_ID, DEMAND_PART_ID,
                      ALLOCATED_QTY, RECEIVED_QTY, ISSUED_QTY
FROM         dbo.DEMAND_SUPPLY_LINK dsl
WHERE     (ROWID =
                          (SELECT     MAX(dsl1.ROWID)
                            FROM          dbo.DEMAND_SUPPLY_LINK AS dsl1
                            WHERE      dsl1.SUPPLY_BASE_ID = dsl.SUPPLY_BASE_ID))

both table and view are in same database

I then went into my report and changed the Datasource Location from Demand_Supply_Link to vwDemandSupplyLinkSingleLinePerWO.

I know CR has redirected to the View because I'm now getting correct data.  However in the Field Explorer and Database Expert it still shows the name "Demand_Supply_Link" not vwDemandSupplyLinkSingleLinePerWO.
  I've even rebooted.  Can it / will it ever show the view name?

thanks.  too bad it can't be more obvious to someone else who looks at this report down the road.


Edited by carstowal - 13 Oct 2009 at 12:03pm

since I'll forget all about it, I created a formula called README
=
//the table SUPPLY_DEMAND_LINK is really pointing to vwDemandSupplyLinkSingleLinePerWO
//see Properties under Table Name in Set Datasource Location


THANKS A MILLION for your continued assistance via this forum.