I'm using CR 11.  I need to figure out how to suppress a sub-report based on data contained in another table not part of the data set used for the reports.
Situation is we have a shipping application that maintains its own data, and when an order is shipped, it automatically prints a packing slip for the order. We have about 500+ customers that also require us to include an invoice in the box when it ships.  Currently, each of these customers must  be configured, one at a time, to also print the invoice. Both reports are CR reports.  I’ve created a SQL table with the customer number of each customer that needs the invoice.  What I want to do is embed the invoice in the packing slip report as a sub-report, and suppress it unless the customer number is in my table. The customer number is a parameter in their report, so I would like to something like:

Suppress If {?custno} not in (select custno from dbo.include_invoice)

Not sure if this can be done, or what the proper syntax would be if you can.  The report does not have access to this table by default, but I could join it in I suppose if necessary.

Thanks,

Mike Bailey