At the bottom of my .view file where I am manipulating data from various datasources, I need to write out the results to a new mysql table. The reason for this is I need to export the data to a Excel sheet. The problem is that I don't have a handle to the dbase in the .view file. Rather, I have access to the dataStores.
Is is possible for me to go directly from my calculated fields (they came from various datastores) and just use Export without the data coming from a table? Something like this?
<?php $report = new MyReport; $report->run()->exportToExcel(array( "fields" => array( "column1" => $mydata1, "column2" => $mydata2, "column3" =>$mydata3 ) ))->toBrowser("myreport.xlsx");