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

Help

Home

Home » Archived » 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 23:36

Neil Wang

Messages: 105
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 171 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 21:28

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

Could you just do a joint dataSet?

Regards,

Michael

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

Michael

Developer Evangelist, Silanis

Report message to a moderator

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

Thu, 14 July 2011 00:57

Neil Wang

Messages: 105
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 21:03

Michael Williams

Messages: 1925
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.