| Dynamic no of pages in a report [message #89659] |
Mon, 14 June 2004 08:06  |
kiran
Messages: 503
Registered: July 2000
|
Senior Member |
|
|
My need is to generate the no of pages dynamically.
I will be generating a label report.
The query will give me a single record.
but i want to generate the label the no. of times as per a particular field value in the record.
For example. if the particular field value is 5. then i have to generate 5 label reports of that particular record.
How to do this?
|
|
|
|
| Re: Dynamic no of pages in a report [message #89661 is a reply to message #89659] |
Mon, 14 June 2004 22:30  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Hi,
Prepare your query on following Guidelines:
1 select deptno,rownum from dept,
2 (select rownum from user_objects where rownum<6)
3* Where deptno=10
SQL> /
DEPTNO ROWNUM
--------- ---------
10 1
10 2
10 3
10 4
10 5
In you case you can remove rownum<6
with
rownum<(select Count_col from Table_name where Labelno=<Labelno>)
HTH
Regards
Himanshu
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
