Limiting an Embedded Crosstab to a Value from the Outer Table

mwilliams

When you filter a crosstab to limit it to the data for the group of the outer table only in newer versions, your filter would compare the crosstab dimension or attribute to the outer table value with a condition like:

data["dimensionName"] Equal to row._outer["rowName"]

<br />
I was working on this same issue for someone in 2.2.1 and it wasn't working correctly. I decided to try just using a statement like the following instead:

data["dimensionName"] Equal to row["rowName"]

<br />
To my surprise, this worked. So, if anyone is struggling with this in an early version of BIRT, you might try doing it this way. This may have just been a bug in 2.2.1, but I figured I'd post a devShare item on it anyways.