Trying to build an table report style
Posted: Fri Nov 22, 2013 5:29 am
Hi NB Team
i am trying to elaborate a table report and i just got blank spaces
this is my code
nuRunQuery(
<<<EOSQL
CREATE TABLE #dataTable#
SELECT *
FROM an_anticipos
ORDER BY fecha_an
EOSQL
);
$resultSet = nuRunQuery("SELECT * from #dataTable# ");
while ($row = db_fetch_object($resultSet)) {
$fecha_an = $row->fecha_an;
$par_progr_an = $row->par_prog_an;
$par_avance_an = $row->par_avance_an;
$avance_prog_an = $row->avance_prog_an;
$avance_avance_an = $row->avance_avance_an;
$desv_prog_an = $row->desv_prog_an;
$desv_avance_an = $row->desv_avance_an;
//nuRunQuery($s);
}
on Report Writer Detail Block fields name`s are $fecha_an (and the rest of fields) results on blanks and if i switch to fecha_an (and the rest of fields without $) results a data row but not the way i need it cause every row appears on every detail block.
I just want to display all rows on one detail block.
Please any advice or help is appreciated.
Thanks.
i am trying to elaborate a table report and i just got blank spaces
this is my code
nuRunQuery(
<<<EOSQL
CREATE TABLE #dataTable#
SELECT *
FROM an_anticipos
ORDER BY fecha_an
EOSQL
);
$resultSet = nuRunQuery("SELECT * from #dataTable# ");
while ($row = db_fetch_object($resultSet)) {
$fecha_an = $row->fecha_an;
$par_progr_an = $row->par_prog_an;
$par_avance_an = $row->par_avance_an;
$avance_prog_an = $row->avance_prog_an;
$avance_avance_an = $row->avance_avance_an;
$desv_prog_an = $row->desv_prog_an;
$desv_avance_an = $row->desv_avance_an;
//nuRunQuery($s);
}
on Report Writer Detail Block fields name`s are $fecha_an (and the rest of fields) results on blanks and if i switch to fecha_an (and the rest of fields without $) results a data row but not the way i need it cause every row appears on every detail block.
I just want to display all rows on one detail block.
Please any advice or help is appreciated.
Thanks.