Eclipse Community Forums: BIRT » How to suppress duplicate data

Home » Archived » BIRT » How to suppress duplicate data

How to suppress duplicate data [message #154689]

Thu, 20 April 2006 06:07

Eclipse User

Originally posted by: riannacmw.yahoo.com.hk

Hello,

My report contains two column list. Some data in column 2 duplicate with
that in the next row. How can I suppress the duplicate? i.e to display a
blank space for the duplicate data.

Rianna

Re: How to suppress duplicate data [message #154904 is a reply to message #154689]

Thu, 20 April 2006 12:16

Eclipse User

Rianna,

I just build a report off the sample db that list all the OrderDetails.
The first column is the order number which is repeated for every entry.
To suppress this I did the following:

On the Table or List, click the script tab and select the onPrepare method.
put in the following

ordernumberlast = "";

Then in the expression builder for the order number change the value to:

if( row["ORDERNUMBER"] == ordernumberlast ){
valtodisp ="";
}else{
ordernumberlast = row["ORDERNUMBER"];
}

This should work.

Jason

"Rianna" <riannacmw@yahoo.com.hk> wrote in message
news:c73132fdf518f83550c789b01f767d90$1@www.eclipse.org...
> Hello,
>
> My report contains two column list. Some data in column 2 duplicate with
> that in the next row. How can I suppress the duplicate? i.e to display a
> blank space for the duplicate data.
>
> Rianna
>
>

Re: How to suppress duplicate data [message #154982 is a reply to message #154689]

Thu, 20 April 2006 17:20

Eclipse User

Originally posted by: dolphycj.xxxxxxxxx.com

You may also want to look into Drop columns.

Re: How to suppress duplicate data [message #155012 is a reply to message #154904]

Thu, 20 April 2006 21:27

Eclipse User

Originally posted by: riannacmw.yahoo.com.hk

Thank you Jason. Your solution works.

Previous Topic:	report parameters ALL_DATES or (START_DATE, END_DATE)
Next Topic:	report viewer

Goto Forum:

-=] Back to Top [=-

Current Time: Mon Sep 01 05:17:19 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter