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 09:59 Go to next message
Kevin is currently offline Kevin
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 10:05 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
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.
>


Jason Weathersby

BIRT Exchange
Re: 2.3.2 suppress records in data set [message #643318 is a reply to message #642977] Mon, 06 December 2010 08:38 Go to previous message
Kevin is currently offline Kevin
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: Sat Apr 19 18:34:39 EDT 2014

Powered by FUDForum. Page generated in 0.01457 seconds