Crystal Reports Reports, Subreports and Global Variables

Message

Good morning.  I have been working on a report in CR 8.5 for quite some time now and am not sure how to proceed.  First let me say that I am a Novice at best with CR, but have been using a reference book and the web to put together a report providing info requested by my Operations department.

This report deals with OFAC false hit reporting and pulls it's data from various tables in an Oracle db.  I've created a main report that lists the false hits over a given time period along with the ID(s) for the corresponding entry (or entries) in the OFAC table.  The ID is not an actual field in any of the tables used for the main report, but is extracted from a text string that may or may not exist.

My primary issue is that I can not (or don't know how) to link the tables I am using in the main report with the OFAC table I need to use.  The requestor of the report wants to see the actual false hit along with the OFAC Summary found in the OFAC table.

Currently, I have created a linked subreport that takes the ID I extracted on the main report an provides the summary info for that ID.  The problem is that there may be multiple IDs for each message in the main report, and I need to provide the summary for each.  I thought I might be able to create the subreport and then create a selection formula inside it that would check each ID and concatenate the summary info for each one together, but this did not work (I don't think I was able to keep looking up new IDs in the db once the subreport executed).

Ideally, the user would run the report for a specific date range and get the following output:

Top N false hits grouped together.  Upon drill down, the user would see each unique false hit along with the OFAC Summary that contains the token matching the hit.

I know this is a lot of info and somewhat convoluted, but I can provide more info if necessary.  It would be great if I could define a global variable in the main report and then concatenate each summary to it in the subreport, but my reference says that global variables can not be referenced in subreports.  I also thought it would be nice if I could use recursion in the subreport and just pass a list of IDs and have it return a string of all the summaries.

Any ideas???