Hi,
I'm trying to create a report but it doesn't return all the pages
If the spaces between rows is larger, the report returns me 11 records.
Otherwise it returns me 21 records.
Also, if I run the same query in SQL*Plus it returns me 665 records.
Here is the query:
SELECT ri2003.magazin,
ri2003.gestiune,
ri2003.fel,
ii.articol_cod,
a.denumire,
ii.cantitate,
ii.cost_unitar,
ii.cost,
ddc.nr
FROM
rezumat_inventar_2003 ri2003,
iesiri_interne ii,
documente_de_consum ddc,
articole a
WHERE
ri2003.docid = ii.doccons_id AND
ddc.id = ii.doccons_id AND
ii.articol_cod = a.cod AND
ddc.id = ri2003.docid AND
ri2003.magazin = _magazin
How can I fix it?
Please help!!
Thanks in advance.
Laura