Support to Collections

[flavioribeirojr]

I don't know if is lack of my knowledge, but i can't discover how to pass parameters that in my report are of the Collection type. Do your library support it?

[geekcom]

Hi @flavio-jr,

Parameters can be used in SQL queries to filter records in a where condition or to add/replace pieces of raw SQL or even to pass the entire SQL string to execute.
In the first case the parameters are used as standard SQL parameters, in example:

SELECT * FROM ORDERS WHERE ORDER_ID = $P{my_order_id}

In this example my_order_id is a parameter that contains the ID of the order to read. This parameter can be passed to the report from the application that is running it to select only a specific order. Please note that the parameter here is a real SQL parameter, meaning that the query will be executed using a prepared statement like:

SELECT * FROM ORDERS WHERE ORDER_ID = ?

Please read this article:
https://community.jaspersoft.com/wiki/using-report-parameters

[flavioribeirojr]

I want to use a WHERE IN statement in my SQL, so i'm passing many ids to my report. In iReport they use a Collection parameter to filter the registers. I just want to know if is possible to pass such parameter type from PHP to Jasper

[flavioribeirojr]

Here is my workaround: I'm passing a string parameter, and in the report I make a "split" to get an array.

[rafaelqueiroz]

@flavio-jr you can provide me a sample of your report ?

[miltonisaya]

PE8b.zip
Provided is the .jrxml file I am working on. I want to pass my parameters using your library. I keep on getting the array to string conversion error. Please assist

[tantanito]

@flavio-jr Do you have a working example? Can't get to work with collections.

[hemimm]

When I put a parameters we have a Fatal error: Uncaught PHPJasper\Exception\ErrorCommandExecutable: your report has an error couldn´t be processed.

I did in JasperSoft Studio: Select * from table Where field between P{field_start} and P{field_end}

In PHPJasper:
require DIR.DIRECTORY_SEPARATOR.'vendor'.DIRECTORY_SEPARATOR.'autoload.php';
use PHPJasper\PHPJasper as PHPJasper;

$file = 'DataMatrix.jasper';
$fieldstart = 'CA1234';
$fieldend = 'CA5678';

$input = DIR.DIRECTORY_SEPARATOR.$file;
$output = DIR;
$options => [
'format' => ['pdf'],
'locale' => 'en'
'params => [
'field_start' => $fieldstart,
'field_end' => $fieldend
],
'dbconnection => [
'driver' => 'mysql',
'username' => 'root',
'password' => 'password',
'host' => 'localhost:8080',
'database' => 'database',
'port' => '3306'
]
$jasper = new PHPJasper;
$jasper -> process($input,$output,$options)->execute();

Without parameters result a blank report, With partameters result the error.

I couldn´t find out the error. I thank for help, and sorry for my bad english.

[geekcom]

Hi @hemimm please check your .jrxml report,
parameters should be used in this way:

$P{my_order_id}

[hemimm]

As my english is not good, I will add information in portuguese.

Para ver as informações passadas, coloque $jasper->process($input,$output,$options)->output e obtive
Jasper starter --locale em process "D:\web\DataMatrix.jasper" -o "D:\web" -f pdf -P field_start = "CA1234" field_end "CA5678" -t mysql -u root -p password -H localhost:8080 -n database --d-port 3306

Espero que com isto ajude a solucionar o problema.

[hemimm]

Yes, it is in this way.

[hemimm]

In JasperSoft Studio, the report is normal, but not in PHPJasper

[hemimm]

the complete error:

Fatal error: Uncaught PHPJasper\Exception\ErrorCommandExecutable: Your report has an error and couldn 't be processed!\ Try to output the command using the function output(); and run it manually in the console. in D:\web\vendor\geekcom\phpjasper\src\PHPJasper.php:219 Stack trace: #0 D:\web\RotulosdaEtiquetasPHPJasper.php(157): PHPJasper\PHPJasper->execute() #1 {main} thrown in D:\web\vendor\geekcom\phpjasper\src\PHPJasper.php on line 219

[hemimm]

line 157 is $jasper($input,$output,$options)->execute()

[hemimm]

Yes, it is in this way. In deed in JasperSoft Studio the report is normal, but not in PHPJasper Enviado do Email<https://go.microsoft.com/fwlink/?LinkId=550986> para Windows 10

…

________________________________ De: Daniel Rodrigues <notifications@github.com> Enviado: Thursday, May 3, 2018 9:37:49 AM Para: PHPJasper/phpjasper Cc: hemimm; Mention Assunto: Re: [PHPJasper/phpjasper] Support to Collections (#64) Hi @hemimm<https://github.com/hemimm> please check your .jrxml report, parameters should be used in this way: $P{my_order_id} — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub<#64 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AeEASsU0NrC_Pb4-nVidd5sMHnwI4lJJks5tuvodgaJpZM4PjUsa>.