<p>I have two datasets:</p>
<p>Dataset1: with the columns "WI_ID, STATE_NAME, CHANGE_DATE,DAYS_IN_STATE,FROM_STATE_NAME,TO_STATE_NAME"</p>
<p> </p>
<p>Dataset2: with the columns "WI_ID,SUMMARY,CREATION_DATE,CREATOR_NAME,WI_TYPE"</p>
<p> </p>
<p>I added new table in WI_State.rptdesign.</p>
<p>Added "WI_ID" and "SUMMARY" from Dataset2 in first and second columns. In third column I dragged Dataset1 with ""WI_ID, STATE_NAME, CHANGE_DATE" fields.</p>
<p>Now, when I run the report, I see the inner table repeating the values.</p>
<p> </p>
<p><strong>I want the result like:</strong> for each WI_ID in the outer column, only the states and change_dates related to it should show up in inner table.</p>
<p>Please see the attached image for the output I am seeing currently.</p>
<p> </p>
<p>Please let me know how to fix this...</p>
<p> </p>
