Select From Report

[Master]

I have noticed there is a 20000 limit for options displaying in a dropdown, how I can I give users the option to see all?

[MayMusic]

Instead of dropdown you can have a text filed in your submission page.

Create a report page to search for options. In Configure Result Page Fields screen add a HTML Block with the code below which is generating a button to select one of the options.

<input  onclick="f_select('[@field:FIELDNAME]')"  type="button"  value="Select [@field:FIELDNAME]" />

Add Header/Footer and paste the code below to Footer:

<script>

function f_select(ln){
window.close();
var element_value= ln;

//Replace the FieldName with the Original DataPage FieldName

window.opener.document.getElementById("InsertRecordFieldName").value=element_value; 

}
</script>

 This will add the value to a text field you have on your submission page.