Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » 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 14:59 Go to next message
Kevin is currently offline KevinFriend
Messages: 4
Registered: December 2010
Location: U.S.
Junior Member

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 15:05 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

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 13:38 Go to previous message
Kevin is currently offline KevinFriend
Messages: 4
Registered: December 2010
Location: U.S.
Junior Member
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:
  


Current Time: Thu Nov 27 13:41:35 GMT 2014

Powered by FUDForum. Page generated in 0.02261 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software