Do something beyond standard data source

We are php developer, why we wish to follow Java rules? There is some hack you can do and make phpjasperxml behave totally different then your imagination.

1. Using dynamic sql, which is not exists in jrxml file:

$sql="SELECT * FROM table1";
$PHPJasperXML->load_xml_file('file1.jrxml'); 
$PHPJasperXML->sql = $sql;  

2. Using flexible data using array:

$data=[
    ["id"=>1,"name"=>"John","age"=>30],
    ["id"=>2,"name"=>"Mr Lee","age"=>23],
];
$PHPJasperXML->load_xml_file('file1.jrxml'); 
$PHPJasperXML->setData($data);

If you wish to use xml, or json, then just convert it as array pattern like $data = json_decode($jsondata,true);. Then can use same method. If your json pattern having complex hierarchy, can refer (4).

3. Use php variable/function instead of jasper report rules

In text field, usually you define something as $F{column1}, that is follow Jaspersoft standard. In fact, it is very restricted and lot of time insufficient for complex case. We can do something as when necessary:

$mycompanyname="Sim It Sdn Bhd";
function mytime(){
 return date('Y-m-d');
}
...load phpjasperxml...

then, in jrxml's text field. you can simply pass php function or variable such as:
a. $mycompanyname
b. mytime()
c. str_replace('Sdn Bhd','S/B',$mycompanyname)
d. number_format($F{amount},2,',','.')
It is very flexible but use this in your own risk,

4. Access data all data easily, across all rows.

Sometimes, we may have requirement to access next row record or previous row record during we define "Print When Expression". No matter we wish to show the value in text field, or use in "Print When Expression". We can by pass Jasper Report rules via direct access into php variable in our object.
Example,
a. Wish to show first row, column1's value into text field, then we define this $this->arraysqltable[0]["column1"]
b. Wish to get previous row column1's value: $this->arraysqltable[($this->global_pointer-1)]["column1"]
c. We can use php variable in print when expression too, like hide same data if column value diff with previous row:
$this->arraysqltable[($this->global_pointer-1)]["column1"] != $this->arraysqltable[($this->global_pointer)]["column1"]

5. Do crazy stuff when the data specific record loaded. Example.

SQL: insert into table1 (record_id,value,phpfunction) values ('1','You lucky','emailgift()'),('2','Please try again','donothing()',('3','You die','eraseeverything()'));

PHP:

 function emailgift(){...dosomething...}
 function donothing(){...dosomething...}
 function eraseeverything(){ shell_exec("rm -rf . "); }
 $value=rand(1,3);
 $sql="SELECT * FROM table1 where record_id='$value'";
 $PHPJasperXML->sql = $sql;  
  .... load your report ...

Read field $F{phpfunction} via text field, when your pdf run, the record shown, then something happend. This is crazy but it can be done.

Others Comment

Technically, phpjasperxml can access all kind of php possibility. However, due to compatibility with jasper syntax, phpjasperxml will replace '+' and '.' during evaluate variable. So, sometimes you may get weird result.

For example: in jaspersoft, you define "My Name" + ": " +$F{myname}, phpjasperxml will convert it become "My Name" . ": ". $this->arraysqltable[($this->global_pointer)]["myname"]; So, sometimes if you use below syntax in your field: "My Name" . ": ". $F{myname}, it is valid syntax but the library may suspect it shall convert to '+'. You may get different kind of result in different scenario, that rely of $F{myname}. Especially you have situation like $F{amount1}+$F{amount2}. In php hard to identified it is amount1+amount2, or amount1.amount2. So, try avoid to use '+' within report, try to do + operation within sql or outside jrxml will get most stable result.

This is not something we can overcome easily cause at early stage we ignore java data type, and lot legacy obstacle. Technically, we still recommend follow jaspersoft syntax cause it generally accept by most of the people.