Passing a list of results to another report (or sub-report)

[gabrielinux]

Hi all,

     I need to run a report from databae A where a PONumber field appears in database B.  Since the databases resided on different servers and are not linked together, I thought maybe I could do this with a sub-report?  Any idea how?

My first query would retrieve a whole bunch of order numbers:

SELECT DISTINCT TicketNumber

FROM A

WHERE A.TicketStatus = 'Open';

 

My second query, and the one for the report I actually need, would look like this:

SELECT PONumber, PODate, POStatus

FROM B

WHERE B.TicketNumber IN (... results from the previous query... );

 

Any idea how I accomplis this?

Thanks!