Crystal XI
SQL database

Have a main report with grouping on a formula , say
Fibre
DSL
Internet
etc
there are 3 groups below this level but probably irrelevent for this question

I want to have a sub report (at each group level) that selects the ID's from the data in the main report (at group level) and passes the ID's from the main report and then selects those records in the subreport based on the contract ID.

The same principal would then be applied to each subsequent group e.g. Internet has 2 groups , I need just the contract ID's being passed to the subreport to give me detail on those contracts

What I am getting is the subreport only returning the FIRST value (contract ID)NOT passing all the values to the subreport.  I have tried manipulating the record selection in the sub report to be "in" rather than "=" etc.  I am still not having success.

Any ideas would be most appreciated.