Bring data in my report through Query

[KATIA DIAS]

Dears, good morning!

I use the 11G version of Reports and Database ....

I need a help from you! I want to bring the following data in my report through Query:

An example
If they are 6 pages, I want to bring sheet 1, sheet 2 and so on .... My report will have a page break and I will print 2 ways with the same data ...

Today I can bring the 2 ways, but in the paginum break, it is not working and I already looked for Here in the topic, but I was not successful. If anyone knows how to bring the information by Query, thank you very much.


Note: It has been a long time ago that I work with Reports ...


Thank you

[tora34]

Good morning, Katia, how are you?
You commented on Query but did not show.
Could try to explain in another way so that we can help her.
I did not understand your explanation.

Your report will have a page break by type of grouping?
Do you want to issue two ways of each page generated?

[KATIA DIAS]

Good morning, TORA !!!

I need to print 2 routes of the same report and control the NR. of pages ....

Ex: I did a similar query ...

Select all

select x.via , xx.numero , xx.data , xx.valor , xx.empresa 
from 
( 
select number , date , amount , company 
receipts from 
where number = p_numero_recibo 
) Xx 
( 
select 1 from dual via 
union 
select 2 from dual via 
) x

If my report has 6 pages ...

I need ...


Report via Customer:
]
Page 1/6
2/6
3/6
4/6
5/6
6 / 6


Report via the warehouse

Page 1/6
2/6
3/6

4/6
5/6
6/6


Note: I tried to duplicate my repeating frame, but anyway I did not get success ... I controlled only one frame the other no ...

If you can help me, thank you very much ...

Katia Dias

[jacksonr81]

Good afternoon Katia

You could try to repeat the same Select with Union and creating a field via both.
Example:

Select all

 
SELECT via, 
       numero, 
       data, 
       empresa 
FROM   (SELECT 1           via, 
               num_pedido  numero, 
               dat_pedido  data, 
               nom_empresa empresa 
        FROM   cad_emp 
        WHERE  cod_emp = 1 
        UNION 
        SELECT 2           via, 
               num_pedido  numero, 
               dat_pedido  data, 
               nom_empresa empresa 
        FROM   cad_emp 
        WHERE  cod_emp = 1) 
--repare que os dois selects internos são identicos, com exessão do campo via 
ORDER  BY via 
-- ordenar pelo campo via fará com que não misture um grupo com o outro 
-- Ordene pela via também no Group do Reports 

ATT
Jackson