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.
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.