Report builder: Insert value from a listbox

I have a similar question, I'd like to be able to build a simple form that identifies the WHERE aspect of the report.

Where Andreas is wanting to add a WHERE hospital = $variable, I'd like to be able to choose a date range, or similar.

I notice in the plugin there's commented PHP with " // parse form input" - is this something that can be extended in the plugin? 

Hi Andreas (and Tim), 

There's no built-in search functionality in Report Builder but you can use PHP code in the queries.  So with this query: 

SELECT surname, name
FROM `<?php echo $TABLE_PREFIX ?>aortic_aneurysm_disease`
WHERE hospital='Athens Hospital'
LIMIT 1000

You could do this (untested code) to get there WHERE value from the request: 

SELECT surname, name, hospital
FROM `<?php echo $TABLE_PREFIX ?>aortic_aneurysm_disease`
<?php if (isset($_REQUEST['hospital'])) { echo mysql_escapef(" WHERE hospital = ? ", $hospital); } ?>
LIMIT 1000

And then you could specify the hospital in the url like this: &hospital=Athens+Hospital

You'd still need to modify the plugin or add some custom code or links to generate those links though.

Hope that helps!

And just noticed, you can also use HTML and PHP in the Description field.  So you could have a list of hospital links there or try adding a pulldown.