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

Help

Home

Home » Eclipse Projects » BIRT » Apply filtering based on inner table field value

Show: Today's Messages :: Show Polls :: Message Navigator

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

Tue, 12 July 2011 19:36

Neil Wang
Messages: 102
Registered: July 2009

Senior Member

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 49 times)

Report message to a moderator

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

Wed, 13 July 2011 17:28

Michael Williams
Messages: 817
Registered: July 2009

Senior Member

Could you just do a joint dataSet?

Regards,

Michael

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

Regards,

Michael Williams
BIRT Exchange
Michael's BIRT Blog

Report message to a moderator

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

Wed, 13 July 2011 20:57

Neil Wang
Messages: 102
Registered: July 2009

Senior Member

Hi,

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

Neil

Report message to a moderator

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

Thu, 14 July 2011 17:03

Michael Williams
Messages: 817
Registered: July 2009

Senior Member

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 31 times)

Regards,

Michael Williams
BIRT Exchange
Michael's BIRT Blog

Report message to a moderator

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

Tue, 19 July 2011 17:21

Neil Wang
Messages: 102
Registered: July 2009

Senior Member

thanks, it's an interesting approach.

Neil

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 22 11:07:26 EDT 2013