<p>Need the solutuion for below scenario.</p>
<p> </p>
<p>I Have 79K GroupId 's and each group id having the sub division Id's.</p>
<p> </p>
<p>Report has been designed to dsiplay the particular Groupid and corresponding division id. </p>
<p> </p>
<p>Group id will be displayed by using the dropdown list and If we have choose any of GroupID from the displayed list, It should display the corresponding Division id automatically by using cascade parameters.</p>
<p> </p>
<p>We have achieved this.</p>
<p> </p>
<p>But Due to 79K group id's we are facing performance issue.</p>
<p> </p>
<p>Instead of that we have filtered to display the minimum number of groupd id's in combo box. for example 50 Groupid's. If we have choose any of groupid from that list, then i am getting corresponding Division id.</p>
<p> </p>
<p>If i want to choose group id which is not in that list(out of 50), i am manually entering the groupid as it was combo box. Here i am not able to getting the corresponding Division id. </p>
<p> </p>
<p>Please suggest to achieve this. </p>
