Fetching single row

rupal

Hi,

I am using BIRT to create a report.I have written a query that fetches me the count of requirements under low,medium and high complexity.The sql query fetches me 3 rows one for each type of complexity.Now i need to multiply each count with its complexity weight.How do i do it.The dataset contains three rows one for count of requirements for each category of reqs.

JasonW

You should be able to add a computed column to the data set with an expression that multiplies count times your weight based on the row value of complexity. For example:

if( row["Complexity"] == "low" ){
wgt = 1;
}else if(row["Complexity"] == "med"){
wgt = 2;
}else{
wgt =3;
}
row["Count"]*wgt;

Jason