supress dulpicates on grouping

swathi

I need to supress the duplicates on grouping with the combination of next column.
we will supress the coloumn1 uisng the logic,
if the second column has the different value then need to show the first column value also.If both values are different then i need to show the both row values else if both are same need to supress both.
Here i used the following oncreate script on cloumn1 but on grouping it doesnt works.
Column1 Column2
JuvenileId CaseId


this.text = this.getRowData().getColumnValue("CASEID");
caseId = this.text;
this.text = this.getRowData().getColumnValue("ID");
juvId = this.text;
if(juvId.equals(reportContext.getGlobalVariable("prevId")))
{
if(caseId.equals(reportContext.getGlobalVariable("prevCase"))){
this.text= "";
} else {
reportContext.setGlobalVariable("prevId",juvId);
reportContext.setGlobalVariable("prevCase",caseId);
}}
else
{
reportContext.setGlobalVariable("prevId",juvId);
}

Urgent help please

---

On next group also it supressess if we have same value....

Virgil Dodson

Hi swathi,

I moved this question into the Designer BIRT Reports forum so you'll have a better chance of people looking at it.