Can any one help me in Generation Report

sridhar

I have two tables say Table 1 & Table 2. Both are related with a field name say "code"

Table 1.

No. count Code

---

1 20 AM
2 30 BM

Table 2.
No. countcode code Description

---

1 AM C1 MECH1
2 AM C2 MECH2
3 BM C3 J4
4 BM C4 J5

I want the report that should look like

code Description

---

AM 20

C1 MECH1
C2 MECH2

BM 30

C3 J4
C4 J5

Can any one please guide me to solve this?

kine

First dataitem - Table 1
Second dataitem - Table 2 - indent by one

DataItemLink on table 2 - connect the fields you want.

In sections add the fields you want to see...