my $stmt = "SELECT store_name, store_num FROM TEST_CORP_LEAS order by store_num"; $query = $connection->prepare($stmt); $query->execute() or die $connection->errstr; my $data = $query->fetchall_arrayref(); $rw->render_report('./layout.xml',\@{$data}); $rw->save();