Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines
I think you could try DataStore's join method:
https://www.koolreport.com/docs/datastore/overview/#join-methods
Then add some processes such as Map, CalculatedColumn, etc to modify column 2's value or create a new column:
https://www.koolreport.com/docs/datastore/overview/#other-methods-process
Let us know if this works for you. Tks,
One more question if I have a datastore in the variable $myds how canget access to it using $this->dataStore('my_datastore')
Maybe it is a stupid question but after some iterations in the myreport.php file, I have my result in the variable so I want to get access to it in myreport.view.php.
In your report setup you can set the variable to be a property of the report itself then access the property in report view:
//MyReport.php
function setup() {
...
$this->var = $var; //$this is the report object
}
//MyReport.view.php
var_dump($this->var);
Let us know if we understand your question correctly. Rgds,
Let KoolReport help you to make great reports. It's free & open-source released under MIT license.
Download KoolReport View demo