Hello, I have a report which is based on the query
select codice, descrizione, qta from magazzino
Table::create(array(
"dataStore"=>$this->dataStore('my_data'),
"columns"=>array(
"descrizione"=>array(
"label"=>"Desc.",
"type"=>"string",
),
"qta"=>array(
"label"=>"Q.tà",
"type"=>"number",
"prefix"=>"#",
)
),
"cssClass"=>array(
"table"=>"table table-hover table-bordered"
)
));
It works very well, I see what I want. But now I want to see a sub-report based on the query for each record
select scatola, codice, qta from scatole
the two queries are joined by the two codice fields. How can I do?