How to make repetition counter? (same as page counter.)

[danilobtos]

Hello everybody...

How to make repetition counter? I will pass a parameter or variable with the number of times the report should be printed. And in the report layout, you must inform the total number of times and the current number of printing. Example: p_CURRENT = 0. p_TOTAL = 5. The p_ATUAL "/" p_TOTAL should appear in the report. on the first 01/05 , on the second 02/05 and so on until the fifth and last 05/05.

[jgust]

There is no built-in functionality for this.

I would always attempt to see if the database can produce the correct records.  In Oracle, I would update the query and use "CONNECT BY LEVEL" to force data duplication.  This will allow the report to be dumb and print the results.

In the example below I used 7 as the :force_cnt.

SELECT SUBSTR(TO_CHAR('0' || ROW_NUMBER() OVER (ORDER BY 'jane doe')), -2, 2)                           || '/' || SUBSTR('0' || TO_CHAR(:force_cnt), -2, 2) AS rn     , 'jane doe' AS student_name     , TO_DATE('03-AUG-1999', 'DD-MON-YYYY') AS birthdateFROM dualCONNECT BY LEVEL <= :force_cnt;[/code]

RN	STUDENT_NAME	BIRTHDATE
01/07	jane doe	03-AUG-1999
02/07	jane doe	03-AUG-1999
03/07	jane doe	03-AUG-1999
04/07	jane doe	03-AUG-1999
05/07	jane doe	03-AUG-1999
06/07	jane doe	03-AUG-1999
07/07	jane doe	03-AUG-1999