Hello Ada,
you could build a form where students fill in their ID and number of labels.
Pass the ID as a parameter to the report and execute the desired number of
calls to run_product. Also, a report can execute another report with the
procedure run_report in the srw package (this was also mentioned in another
thread 'Reports with more than 2 destinations').
Hope this helps.
Regards, Joost
--
Joost Bataille
University of Amsterdam ICT centre
www.ic.uva.nl
remove VERWIJDER_DIT to reply
"Ada" <ada106_at_yahoo.com> wrote in message
news:6bd047ec.0204241730.4db7df6a_at_posting.google.com...
> 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 Fri Apr 26 2002 - 14:22:14 CDT
