Hi Naga,
That's a very nice question of your. It is possible. You can create report object and send customer login through report params, for example:
$report = new DynamicDatabaseReport([
"db"=>[
"connectionString"=>"mysql:host=localhost;dbname=your_customer_db"
"username"=>"customer_login_name",
"password"=>"password_come_here",
"charset"=>"utf8"
]
]);
$report->run()->render();
And here is your DynamicDatabaseReport.php
:
class DynamicDatabaseReport extends \koolreport\KoolReport
{
function settings()
{
return array(
"dataSources"=>array(
"db"=>$this->params["db"]
)
);
}
function setup()
{
$this->src("db")
->query("...")
->pipe(...)
...
->pipe($this->dataStore("data"));
}
}
As you can see, you can create a common report for your customers and send the login detail to report so that report can connect to specific customer database to withdraw data.
Hope that helps.
Let me know if you need further assistance.
Regards,
Karl