Multiple Related data bands

[rchekkath]

Dears


i have a report where i am sending two datatables

Table1

Phase | Class | Mark | TotalStudents | Subject |Status
P1 | 1A | A+ | 50 | ENG | Good
P1 | 1B | E | 45 |ENG | Below Target
P2 | 2A | A+ | 50 | ENG | Good
P2 | 2B | A+ | 50 | ENG | Good
P2 | 2A | A+ | 50 | MATH | Good
P2 | 2B | A+ | 50 | Math | Good
Table2

Phase | AVG_Mark | TotalStudents | Subject | Status
P1 | B- | 95 | ENG | Average Targert




What i would am doing is

Groupheaderband : table1.Subject

ENG
Databand : Table1
P1 | 1A | A+ | 50 | ENG | Good
P1 | 1B | E | 45 |ENG | Below Target
P2 | 2A | A+ | 50 | ENG | Good
P2 | 2B | A+ | 50 | ENG | Good

DataBand2 : Table2
But here i want only the data of ENG to be populated. i tried subreport and relations , databand in Groupfooter but not able to get this to work.

any idea would be highly appreciated.

[Lech Kulikowski]

Hello,

You can add an additional data source with all Subjects and use it as a master for your two details tables.

Thank you.