How to Pass SQL for dynamic select options in Variable Header

[ghost]

Hi @jdorn ,

I want to pass an SQL to variable header select options, but I am unable to do using phpReports Include Header. Please provide any solution as early as possible.

Thanks, Sreekanth

[jdorn]

Use the database_options property to populate a variable select box from a database. http://jdorn.github.io/php-reports/#VariableHeader

[ghost]

Thanks JDorn for your quick response.

[fillipevieira]

Hi, could you show me an example ?

my code doesn't work...

[haglerw]

Hi jdorn,

For MySQL reports, it's possible to use database_options to bring in dynamic options for a select variable but the same can't be possible for PHP Reports, the select input remains blank. How do we go about this? Thank you.

See the attached screenshot.

[apcloic]

@haglerw Same issue here, did you find a solution ?