Eclipse Community Forums: BIRT » Apply filtering based on inner table field value

Home » Archived » BIRT » Apply filtering based on inner table field value

Apply filtering based on inner table field value [message #695964]

Tue, 12 July 2011 19:36

Eclipse User

Hi,

I am trying to apply filtering based on an inner table field value.

Please have a look at the template in attachment. If I would like to display the employee and office info when the office info is not San Francisco, is there a way to do this? I tried setting the filter for the outer table but it doesn't have the visibility of the fields in inner table.

please advise.

Neil

Attachment: EmployeeAndOffice.rptdesign
(Size: 36.39KB, Downloaded 190 times)

Re: Apply filtering based on inner table field value [message #696397 is a reply to message #695964]

Wed, 13 July 2011 17:28

Eclipse User

Could you just do a joint dataSet?

Regards,

Michael

BIRT Evangelist on
http://www.birt-exchange.org

Re: Apply filtering based on inner table field value [message #696443 is a reply to message #696397]

Wed, 13 July 2011 20:57

Eclipse User

Hi,

If I use joint dataset, the performance will take a big hit; therefore, I need to keep the structure. please advise.

Neil

Re: Apply filtering based on inner table field value [message #696805 is a reply to message #695964]

Thu, 14 July 2011 17:03

Eclipse User

Here's a way to do it. I step through the office dataSet and create an array of the San Francisco offices. In this case, it ends up being a single office. I then add a filter to the employee dataSet to filter out employees from any office code in this array. In the design, you need to put an element bound to your inner dataSet at the top. I used a simple text box and hid it. Let me know if you have questions.

Attachment: EmployeeAndOffice2.rptdesign
(Size: 40.04KB, Downloaded 139 times)

Re: Apply filtering based on inner table field value [message #698639 is a reply to message #696805]

Tue, 19 July 2011 17:21

Eclipse User

thanks, it's an interesting approach.

Neil

Previous Topic:	Custom BIRT 3.7 application and classpath
Next Topic:	BirtViewer libraries

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jul 25 19:17:43 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter