<p>Hello,</p>
<p> </p>
<p>I have created two databases and need to populate the data in Dataset2 depending on data in Dataset1 </p>
<p>I am using flat data source for both datasets.</p>
<p>DataSet1 has columns "Premise", "RollNumber" - (Approximately 10000 entries)</p>
<p>I have different premises path, hence I have applied filter with Report Parameter to get rows with specific premise path. (here we have multiple RollNumbers with same premise path)</p>
<p>DataSet2 has columns "RollNumber", "DateTime", "Readings"</p>
<p> </p>
<p>Now scenario is</p>
<p>1. first I want to fill dataset1 with all the rows in csv file.</p>
<p>2. Depending upon RollNumbers column, I want to apply a filter on Dataset2 such that get the data only for specific RollNumbers which are populated in Dataset1</p>
<p> </p>
<p>What I have tried till date -</p>
<p>1. I have created filter for Premise using Report parameter</p>
<p> </p>
<p>I want to know how can I do the further step for filtering Dataset2 data depending on RollNumbers from DataSet1.</p>
<p> </p>
<p>Regards</p>
<p>Samir</p>
