Database Query slow two databases

I have cyrstal reports that need to read from two different databases.  Normally when my reports look at just one or the other database they read and return the records extremely fast.  But when I connect to both in one report, record reading slows to a craw.  What used to take a split second to run a portfolio holdings report now takes up to a minute or more.  You can imagine if I have a grouped report pulling 100 or more accounts, this is not acceptable.

See the  example below where I connect to both databases (FoxPro & CRM).  Please note that this example is a little more complicated then my typical report that connects to both databases b/c i had a situation that required me to connect the "Trade" table in the CRM database to itself to pull related (linked) trades:

Also, link order and "link ordering is enforced"...how does that play into the speed of it all?

Version: CR-XI

Connections:
investor.iaccountid --> trade.iaccountid (inner join)
receiver.raccountid --> trade.raccountid (inner join)
trade.tradeid --> FilteredNew_trade_New.new_tradenumber (left outer join)
FilteredNew_trade_New.new_sourceid --> FilteredNew_trade_OLD.new_tradeid (inner join)

Query:

Sterling Free Tables
 SELECT `receiver`.`r_letter`, `receiver`.`r_address1`, `receiver`.`r_city`, `receiver`.`r_state`, `receiver`.`r_zip`, `receiver`.`raccountid`, `receiver`.`r_email`
 FROM   `receiver` `receiver`
 WHERE  `receiver`.`raccountid`='60343'
 EXTERNAL JOIN receiver.raccountid={?Sterling DBC: trade.raccountid}


Sterling DBC
 SELECT `trade`.`aafsuffix`, `trade`.`iagentid`, `trade`.`settle_i`, `trade`.`prin_i`, `trade`.`basis_i`, `trade`.`days_i`, `trade`.`mdate_i`, `trade`.`rgross`, `trade`.`rnet`, `trade`.`cgross`, `trade`.`igross`, `trade`.`blocknum`, `trade`.`rbill`, `trade`.`cbill`, `trade`.`ibill`, `trade`.`icobbill`, `trade`.`rcobbill`, `trade`.`i_comment`, `trade`.`tradeid`, `trade`.`raccountid`, `trade`.`iaccountid`
 FROM   `trade` `trade`
 WHERE  `trade`.`raccountid`={?Sterling Free Tables: receiver.raccountid} AND `trade`.`mdate_i`>{d '2013-09-19'} AND `trade`.`settle_i`<={d '2013-09-19'} AND  NOT (`trade`.`rcobbill`='B' OR `trade`.`rcobbill`='P') AND  NOT (`trade`.`i_comment` LIKE 'non uss' OR `trade`.`i_comment` LIKE 'Non-uss')
 EXTERNAL JOIN trade.iaccountid={?Sterling Free Tables: investor.iaccountid} AND trade.tradeid={?uss_crm: FilteredNew_trade_New.new_tradenumber}


Sterling Free Tables
 SELECT `investor`.`i_letter1`, `investor`.`i_city`, `investor`.`i_state`, `investor`.`iaccountid`
 FROM   `investor` `investor`
 WHERE  `investor`.`iaccountid`={?Sterling DBC: trade.iaccountid}


uss_crm
 SELECT "FilteredNew_trade_New"."new_sourceid", "FilteredNew_trade_OLD"."new_settleon", "FilteredNew_trade_OLD"."new_days", "FilteredNew_trade_OLD"."new_bcgrossrate", "FilteredNew_trade_OLD"."new_brname", "FilteredNew_trade_OLD"."new_brnetrate", "FilteredNew_trade_New"."new_tradenumber"
 FROM   "crm_MSCRM"."dbo"."FilteredNew_trade" "FilteredNew_trade_New" INNER JOIN "crm_MSCRM"."dbo"."FilteredNew_trade" "FilteredNew_trade_OLD" ON "FilteredNew_trade_New"."new_sourceid"="FilteredNew_trade_OLD"."new_tradeid"
 WHERE  "FilteredNew_trade_New"."new_tradenumber"={?Sterling DBC: trade.tradeid}