Multiple master data

[amrithasatheesh]

hi all

I am having two tables as shown below .

ABC Data

sl Cource sub Department

1 Cource1 sub1 department1
2 Cource2 sub2 department1
3 Cource3 sub3 department2
4 Cource4 sub4 department2

XYZ Data



sl availability Count Code Department

1 availability1 Count1 Code1 department1
2 availability2 Count2 Code2 department1
3 availability3 Count3 Code3 department2
4 availability4 Count4 Code4 department2

I am trying to make a report in following format based on the tables.


Department 1

ABC Data

sl Cource sub Department

1 Cource1 sub1 department1
2 Cource2 sub2 department1


XYZ Data



sl availability Count Code Department

1 availability1 Count1 Code1 department1
2 availability2 Count2 Code2 department1


Department 2

ABC Data

sl Cource sub Department

3 Cource3 sub3 department2
4 Cource4 sub4 department2


XYZ Data

sl availability Count Code Department

3 availability3 Count3 Code3 department2
4 availability4 Count4 Code4 department2


Can anyone guide me ?

Amritha

[Alex K.]

Hello,

In this case you can use master-detail-subdetail report.

Thank you.