here's my question on my crystal report:

 

I have a report on which there are three parts. Part1 will be a sub reports on the page header, part2 will be the detail data section, and part3 will be the summary on the pagefooter.

 

at the same time, there are three kinds of records in my table: dataCat1 is with flag 'A',  and dataCat2 with anyother flag 'C' 'D'....

 

I am asked to do:

 

1. for header(Part1)

 

     put summary of dataCat1 and dataCat2, and some other information(such as  name, address..)

 

2. for detail section

 

if (dataCat2 has records in it  )

then

     print dataCat2 in Detail part, Part2

else

     print dataCat1

 

3. for footer(Part3)

 

    summary data of details section

 

I created views in the project and can do 1 and 3 well, but don't know how to finish the detail section.

 

Could somebody show me how to write a selection to get the right record set?

 

Thanks