I am developing a report where a user will select client's name from dropdown and based on the selected client which is select another dropdown list must be populated with the selected client's invoices.

I have not been able to dynamically populate the list containing invoice numbers of the selected client.

Can you please provide an example or tips how to solve this issue.

Thanks in advance

Thank you very much for the reference:

I am still having a bit of trouble binding data and updating subreport when subReport.update method is called a variable "leping" should be set as parameter. However it does not. I have debugged by displaying this variable via window.alert and it is correctly collected from the combo box but when the subReport is updated it still behaves as if this parameter would be NULL. my code

<div class="form-group">
    <label>Vali klient:</label>
    <?php
    Select::create(array(
        "name"=>"lepingsel",
		"id"=>"lepingsel",
		"dataStore"=>$this->dataStore("kliendid"),
        "defaultOption"=>array("--"=>null),
		"dataBind"=>array(
                "text"=>"kliendinimi",
                "value"=>"lepinguid"
		),
		"clientEvents"=>array(
            "change"=>"function(){
                subReport.update('clientselecting',{
                    leping:$('#lepingsel').val(),
                });
                subReport.update('clientparcelslist');
				window.alert($('#lepingsel').val());
            }",
        ),
        "attributes"=>array(
            "class"=>"form-control",
        )
    ));
    ?>                
</div>

<?php
if($this->params["leping"])
{ // from here it behaves as the parameter is set to NULL

But first I need to populate the second dropdown list of my subreport and this part on code is not run because the parameter leping is not set and therefore a default value is still set.