Print two paths of the same report and can paginate correctly

[KATIA DIAS]

Good night dear!!!

I created a report, in which the same prints two equal ways. Away, perfect! Now, I need the paging to skirt correctly.
Example:

When printing, the report has 3 pages that would be:
1/3
2/3
3/3 OK.
I want to ask for two ways. So when it printed at 3 and return to print again, continue
1/3
2/3
3/3 and not until 1/6 ...

Thanks !!!

[jacksonr81]

Good afternoon

See if the code below helps you.
I used the column via the information in two blocks of equal values ??and the index column to identify the page that you want to print, and each index is to be created again.

Select all

 
select via, indice, folha, numero , data , valor , empresa from ( 
(select via, rownum indice, folha, numero , data , valor , empresa from( 
select 1 via,  1 folha, 123 numero, sysdate data, 999.90 valor, 'Empresa' empresa from dual union 
select 1 via,  2 folha, 123 numero, sysdate data, 999.90 valor, 'Empresa' empresa from dual union 
select 1 via,  3 folha, 123 numero, sysdate data, 999.90 valor, 'Empresa' empresa from dual union 
select 1 via,  4 folha, 123 numero, sysdate data, 999.90 valor, 'Empresa' empresa from dual union 
select 1 via,  5 folha, 123 numero, sysdate data, 999.90 valor, 'Empresa' empresa from dual union 
select 1 via,  6 folha, 123 numero, sysdate data, 999.90 valor, 'Empresa' empresa from dual union 
select 1 via,  7 folha, 123 numero, sysdate data, 999.90 valor, 'Empresa' empresa from dual)) 
union 
(select via, rownum indice, folha, numero , data , valor , empresa from( 
select 2 via, rownum indice, 1 folha, 123 numero, sysdate data, 999.90 valor, 'Empresa' empresa from dual union 
select 2 via, rownum indice, 2 folha, 123 numero, sysdate data, 999.90 valor, 'Empresa' empresa from dual union 
select 2 via, rownum indice, 3 folha, 123 numero, sysdate data, 999.90 valor, 'Empresa' empresa from dual union 
select 2 via, rownum indice, 4 folha, 123 numero, sysdate data, 999.90 valor, 'Empresa' empresa from dual union 
select 2 via, rownum indice, 5 folha, 123 numero, sysdate data, 999.90 valor, 'Empresa' empresa from dual union 
select 2 via, rownum indice, 6 folha, 123 numero, sysdate data, 999.90 valor, 'Empresa' empresa from dual union 
select 2 via, rownum indice, 7 folha, 123 numero, sysdate data, 999.90 valor, 'Empresa' empresa from dual))) 
order by 1, 2 

ATT
Jackson