Eclipse Community Forums: BIRT » 2.3.2 suppress records in data set

Home » Archived » BIRT » 2.3.2 suppress records in data set(Cannot find a way to filter records in a data set in 2.3.2)

2.3.2 suppress records in data set [message #642970]

Fri, 03 December 2010 09:59

Eclipse User

I need to eliminate rows from an XML data set based on a calculated date, which makes a report parameter not easily applicable -- at least to the best of my limited BIRT knowledge.

I am using BIRT 2.3.2 and cannot upgrade for a variety of reasons. My Google searches have shown data set "filter" options for other BIRT versions, but which are not shown in this version.

I can calculate the date (the first day of the current month) in the report's initialize event script, then I need to check it against a date column in each row of data, showing only those rows that are after that date. I suspect this is easy to do, and that I just don't know the proper BIRT terminology to find it.

Re: 2.3.2 suppress records in data set [message #642977 is a reply to message #642970]

Fri, 03 December 2010 10:05

Eclipse User

Kevin,

In BIRT 2.3.2 the xml datasoure/dataset allows adding a filter. You
should be able to choose the date column in first drop down, in the
second column put greater than and in the value1 box enter the script
you are using to calculate the first data of the current month. No need
to put it in the initialize event. If you post a sample xml I can build
you an example.

Jason

On 12/3/2010 9:59 AM, Kevin wrote:
>
> I need to eliminate rows from an XML data set based on a calculated
> date, which makes a report parameter not easily applicable -- at least
> to the best of my limited BIRT knowledge.
>
> I am using BIRT 2.3.2 and cannot upgrade for a variety of reasons. My
> Google searches have shown data set "filter" options for other BIRT
> versions, but which are not shown in this version.
>
> I can calculate the date (the first day of the current month) in the
> report's initialize event script, then I need to check it against a date
> column in each row of data, showing only those rows that are after that
> date. I suspect this is easy to do, and that I just don't know the
> proper BIRT terminology to find it.
>

Re: 2.3.2 suppress records in data set [message #643318 is a reply to message #642977]

Mon, 06 December 2010 08:38

Eclipse User

Thanks Jason. I knew it was easier than I was making it out to be. Since I had to calculate the date, I was thinking that I needed to do the comparison in a script as well. But the filter expression can reference the calculated date and works great.

Previous Topic:	Navigation in BIRT PDF report
Next Topic:	how to set data source connection string at runtime

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Jul 24 22:43:12 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter