Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines
Hi,
I am working on a Koolreport that has 2 Multi-Select filters and second filter needs to be updated based on the first filters selected values. I have tried replicating the example listed here https://koolreport.com/examples/reports/others/subreport_demo/ But seems like the example is only working for single select filter. Is there any way the same could be done for multiple selection?
The example could work for multi select filter. Just remember that for a multi select filter its value ($this->params["myMultiSelect"]) is an array instead of a scalar value (like a string, a number, a date,..). Thus, if you want to filter using sql query you must use the operator IN instead of =. Or you could filter with our Filterprocess using the filter array.
Let us know if you have any difficulty or trouble implementing it. Tks,
It could be because your select is right inside the subreport that its change event makes that subreport updating, thus leading to loop. Pls copy our example with their exact structure of subreports, only add "multiple" => true for the select. If it still doesn't work pls post your code for us to check it for you. Rgds,
Let KoolReport help you to make great reports. It's free & open-source released under MIT license.
Download KoolReport View demo