Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines
You do this:
function setup()
{
$this-src('db')->query("{your query to get the parameters}")
->saveTo($params_src)
->pipe($this->dataStore('params'));
$params_src->start();
//Now you can get the params from dataStore
$params = $this->dataStore("params")->data();
//The $params is an array of associate array containing your parameters
//Now you can continue to get your real query
$this->src('db')->query("{Your real query}")
->params(array(
":myparam"=>$params[0]["name_of_param"]
))
->pipe($this->dataStore('results'));
}
Hope that helps.
Let KoolReport help you to make great reports. It's free & open-source released under MIT license.
Download KoolReport View demo