Spreadsheets outputting no data, only lterals

Jon Juracich commented on Apr 12

We are working with a client to upgrade their PHPPOS application from version 14.17 to 19.0. The earlier version was written in CodeIgniter2, while the newer version uses CodeIgniter3.

A number of custom pages and reports were written using KoolReport, and we are having an issue with two in particular. In the code snippet below, it appears that well over 200 elements are being passed in the $allocations variable:

$report = new $reportClass( [ "datasource" => $allocations ] );
$report->run()->exportToExcel('../../views/business_intelligence/export_templates/' . $template)->toBrowser("$template.xlsx");

The KoolReport custom code is identical between the old and new versions of the code - that is, the code was copied from the earlier version to the newer version,

Any suggestions that can be provided as to where to look or what might be missing would be greatly appreciated.

Thanks!

Sebastian Morales commented on Apr 15

If you use a very simple excel template file, such as:

<div>
    <div>
        Simple text
    </div>
</div>

What would be the result?

Jon Juracich commented on Apr 15

Sebastian, the output is "Simple Text" in row 1, column 1.

Sebastian Morales commented on Apr 22

Sorry for the delay. Would you pls print out $allocations and let us know its value?

Jon Juracich commented on Apr 23

No problem, Sebastian.

Apparently, this was a data issue, not a functional issue. I have closed the issue.

Thanks!

KoolReport's Forum

Spreadsheets outputting no data, only lterals #3281

Build Your Excellent Data Report