crystalsubreport-subdatarepeat.jpg

See attached diagram.

I have a report which contains a SubReport, for which in some cases the records are also attached via another module of data (which I am calling SubSubData), where there may be more than one attachment, but I'm only interested in one of them, based on a date constraint. I need to find a way for the SubReport to only allow inclusion of SubData from the attached module based on the required date restriction on a particular field. Is this possible?

Without a restriction on which SubSubData attached records to use, the SubReport is repeated for the number of attached records there are in the SubSubData field... and of course, I can't put a SubReport inside a SubReport!

Anyone have a solution or suggestion?

cheers

Karen