Passing values to sub reports

megabri

<p>I have a birt report that has two data sets.  The first is a parent data set and the second is a child data set.  The parent has information on work order like so:</p><p> </p><p>Wonum  Work Description</p><p>1000       Light bulb replaced</p><p>1001       Wires changed out</p><p>1002       I beam moved to a new location</p><p> </p><p>The child has people who were assigned to each work order so it would be like this:</p><p>Wonum  Person</p><p>1000      John Smith</p><p>1001      Mike Jones</p><p>1001      Joe Shmoe</p><p>1001     Bob Sanchez</p><p>1002     Sam Ryan</p><p> </p><p>I set the report up so the parent data set is tied to a table element and the child data set is tied to a table that is inside the parent table.  I try to pass the parent's wonum information to the child table by doing rows[0]["wonum"] but it only shows the first value.  So information for wonum 1000 comes up but 1001 and 1002 don't show.  Any advice?</p>

pricher

<p>Hi,</p><p> </p><p>In the Assignments table, you need to add a filter in the properties for that table. The filter will act as a join between the AssignmentDataSet and the MainDataSet, based on the common fields between the two tables.</p><p> </p><p>I have attached an example using Customers and Orders in Classic Models. Look at the Filter for the table that contains the Ordernumber: you will see a join between CustomerNumber in the Orders table and CustomerNumber in the Customers table (a.k.a. the outer table)</p><p> </p><p>Hope this helps,</p><p> </p><p>P.</p>