Creating reports based on 2 data sets

chandra t

<div>In the report have 2 datasets, I need to create a group by report , group by x,,y,z  which were present in 1st dataset</div><div> </div><div>but in the detail row I need to get the data from 2 dataset based on parent wonum, </div><div> </div><div>Need a suggestion how to bind the data with the main table in the report?</div>

bgbaird

<p>Chandra, if you can't get the all in a single dataset, you might try binding a table to the parent dataset, then bind a child table in each detail row.  Another method is to create a JOIN dataset in the report design.</p><p> </p><p>Here's two different examples in a link I'll keep active for a few weeks.</p><p> </p><p><a data-ipb='nomediaparse' href='https://file.ac/NzSnP354EdM/'>https://file.ac/NzSnP354EdM/</a></p><p> </p><p>Brian</p&gt;