the only way you can do this in Cr is to use a subreport....
or my favorite, make a stored proc and do the work there, set a flag or however you want to identify different groups you want to see.
CR doesn't allow you to read the data to search for something...it reads every line in the datatable once. You can tell it to not display or to perform so logic, but it won't let you back up once you've found (or not) what you are looking for.
A subreport on the other hand is a fresh look at the data...and because it is a fresh look, it is another hit to the database, which if there are too many can make your report run slowly.
HTH
IP Logged
