Re: Oracle Report: Dynamic Copies of Address Labels
Date: Thu, 25 Apr 2002 16:42:39 GMT
Message-ID: <3CC831FE.D8658E09_at_exesolutions.com>
Ada wrote:
> 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
Load a global temporary table with a stored procedure or SQL statement and report from that.
PS: And please don't cross-post.
Daniel Morgan Received on Thu Apr 25 2002 - 18:42:39 CEST