How to Compare record column data with previous record column data

USHA

Hi

How to Compare present record column data with previous record column data?
If present record column data is same as the previous column data i have to display only the amount column data in the previous record only and it should display blank in the present record.
Check the below example
Input:

---

Col1 Amount
123 50 (Previous record)
123 50 (Present Record)
245 100
245 100

---

output should be:

---

Col1 Amount
123 50
123
245 100
245

---

I am using BIRT 3.2.15

Thanks in Advance
Usha

Davolio

<a class='bbc_url' href='http://www.birt-exchange.com/forum/designing-birt-reports/12472-table-filtered-data.html?=newpost&t=12472'>http://www.birt-exchange.com/forum/designing-birt-reports/12472-table-filtered-data.html?=newpost&t=12472</a><br />
<br />
I think is similar to what you're doing. I created a text box and a global variable to save the previous record value then compared it to the current one.<br />
<br />
Run this script onCreate for each Cell.<br />
<br />
this.text = this.getRowData().getColumnValue("comlumIwantToSave");<br />
if(this.text.equals(reportContext.getGlobalVariable("previousVal")))<br />
{<br />
this.text = "";<br />
}<br />
else<br />
{<br />
reportContext.setGlobalVariable("previousVal",this.text);<br />
}<br />
<br />
Hope that helps,<br />
<br />
Dave