Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines
You can set up a report to use koolreport\datasources\PostgreSQLDataSource
or \koolreport\datasources\PdoDataSource
, then use your views in select query like tables:
class MyReport extends \koolreport\KoolReport
{
public function settings()
{
return array(
"dataSources"=>array(
"automakerPostgre"=>array(
'host' => 'localhost',
'username' => 'root',
'password' => '',
'dbname' => 'automaker',
'class' => "\koolreport\datasources\PostgreSQLDataSource"
),
"automakerPdoPostgre"=>array(
"connectionString"=>"pgsql:host=localhost;dbname=dvdrental",
"username"=>"root",
"password"=>"",
'class' => "\koolreport\datasources\PdoDataSource"
),
)
);
}
public function setup()
{
$this->src('automakerPostgre')
->query("SELECT * FROM my_view")
->pipe(..)
->pipe($this->dataStore(...));
}
If there's any issue let us know right away. Tks,
Let KoolReport help you to make great reports. It's free & open-source released under MIT license.
Download KoolReport View demo