Re: Oracle Report: Dynamic Copies of Address Labels

For these questions you can use a dummy table with a number column dummy. the table contains numbers from 1 til at least the maximum numbers of labels you have to print

In the report join the dummy table with your select and add the selectclause "and dummy <= :student_labels"

"Surfnet" <j.r.l.m.batailleVERWIJDER_DIT_at_uva.nl> schreef in bericht news:aac9ap$gfk$1_at_news.surfnet.nl...
> 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 May 03 2002 - 22:23:44 CEST