Hi
I am using database as Oracle 9i and Crystal XI as reporting.
 
I wanted to know
how to display the whole group if one record of the group satisfies the condition in Crystal XI

Example
-----------
 I have some group level
    group1- Campaign Code
      group2- Country Code
        group3-- Project Code
 In a project some active sponsors are present

 If the number of active sponsors in single  project > 25 the the whole Campaign group ( i.e from group1- Campaign Code) should diplay in the report.

can anyone please help me out for that. Its really required in Urjency. So please help me out.
Anup