Oracle Report: Dynamic Copies of Address Labels

Hi,

I have to build an address label report with the following interface:

Student ID        Number of Labels
123456789         2
987654321         5
223344556         6

User can input Student ID and Number of Labels to generate several copies of address label of students according to the input of 'Number of Labels'. Now, I can only generate an address label report for each student id with "one" copy, but not according to the input of 'Number of Labels'.

There may be two possible directions:
1) Write a SQL statement
2) Set properties of the report

Are they possible? If yes, how?
Or any ideas?

Thanks for your help!

Ada Received on Wed Apr 24 2002 - 09:03:33 CEST