Compare two tables and derive third

RobbieBIRT

Hi,

I would like to compare two tables with same headings (i.e., Colum names) and create a third table ( in a dynamic sense), indicating if the values between the tables differ, i.e., indicate the value Gap (Table 3).

The reason for doing this is that I want to demonstrate that with BIRT one can compare "Required level of competencies" required execution of different roles (Table 1) and the "Actual Persons Competencies" executing those roles (Table 2).

I realise that I need some generic approach since writing computed column (Table 3) for each new person is an exhausting and static job., see e.g.,

if ( row["Required-Role-Person:: Competence 1"] == row["Actual::Competence 1"]) {
row["GapOK"]
}
else {
row["GapNOK"]
}

mwilliams

So, are these crosstabs or regular tables? Can you show what the data in your different dataSets looks like? Thanks!