Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines
Hi, We use kool report in laravel. And our app is multi tenant. so each domain has their own database. but when working with kool report it always uses central DB not tenant based DB.
Any suggestion to make it work in multi tenant app. We have used this package for tenancy : https://github.com/stancl/tenancy
You can set the connection for report through parameters, for example:
$report = MyReport([
"tenantDB"=>[
"connectionString"=> "...",
"username"=>"...",
"password"=>"...",
]
]);
And in the report class you can do:
class MyReport extends \koolreport\KoolReport
{
function settings()
{
return [
"dataSources"=>[
"tenantDB"=>$this=>params["tenantDB"]
]
];
}
}
Hope that helps.
Let KoolReport help you to make great reports. It's free & open-source released under MIT license.
Download KoolReport View demo