Crystal Report

[ajr1705]

Hi I have 3 tables which I am linking but its giving me more information than i need see example below.

Table 1 linked to table 2 and 2 linked to 3

Table 2 to contains 3 record and table 3 contain 8

I need to extarct the 3 and 8 records in deatil of the report

TB1
no Amount
1 10
2 20
3 30

TB2

No Date
1 1
1 2
2 3
2 4
2 5
2 6
3 7
3 8


How do i extract this information without writing a sub report

Thank you

 

[MisterMo]

Group by Field 1 and place add a summary of field 2
put the summary field on the group header
Suppress detail section


-Mo