Re: Oracle Reports

Create a user parameter p_test_num and
assign initial value to it.
Make sure that that user parameter is of CHARACTER Datatype.
Then, create a query as:
SELECT TEST_NUM
from TABLE
where TEST_NUM in (&P_TEST_NUM)

YOu can also built the param. form to show the parameter you created which you can manipulate at runtime.

Hope this helps.

• Sophie Schaaf <eschaaf_at_goodegg.com> wrote:
  > Are you using the lexical parameter rather than the
  > bind?
  > I've used this syntax as in this example, and as
  > long as it is a lexical
  > parameter, it works!
  > (this is using Reports 2.5... I'm pretty certain
  > I've used it in Reports 6.0
  > as well...)
  >
  > > >SELECT TEST_NUM
  > > >from TABLE
  > > >where TEST_NUM in (&P_TEST_NUM)
  >
  > Sophie
  > ----- Original Message -----
  > To: Multiple recipients of list ORACLE-L
  > <ORACLE-L_at_fatcity.com>
  > Sent: Friday, August 18, 2000 8:04 AM
  >
  >
  > > This is how you would do it in SQL. I am in the
  > query form of Oracle
  > > Reports. When you enter the string of numbers in,
  > the bind variable is
  > > expecting one value and does not recognize the
  > commas. Therein lies the
  > > trick somewhere and I am not sure where it is!
  > >
  > > Thanks for trying though, if you have any other
  > info, please pass it on.
  > >
  > > Peter
  > >
  > >
  > > >From: "William Beilstein" <BeilstWH_at_obg.com>
  > > >Reply-To: ORACLE-L_at_fatcity.com
  > > >To: Multiple recipients of list ORACLE-L
  > <ORACLE-L_at_fatcity.com>
  > > >Subject: Re: Oracle Reports
  > > >Date: Thu, 17 Aug 2000 13:10:23 -0800
  > > >
  > > >replace your query with
  > > >
  > > >SELECT TEST_NUM
  > > >from TABLE
  > > >where TEST_NUM in (&P_TEST_NUM)
  > > >
  > > >This will be expanded at query time to include
  > the bind variable
  > > >P_TEST_NUM. If you do this, you will have to make
  > sure the user enters
  > the
  > > >values in the following form
  > > >
  > > >10,11,12,13,40,50
  > > >
  > > >
  > > > >>> "Peter Hazelton" <peterhazelton_at_hotmail.com>
  > 08/17/00 03:46PM >>>
  > > >I have a parameter set up on my report. Call it
  > :P_TEST_NUM.
  > > >
  > > >My SQL query will be:
  > > >
  > > >SELECT TEST_NUM
  > > >from TABLE
  > > >where TEST_NUM = :P_TEST_NUM
  > > >
  > > >I want this parameter to accept several different
  > numbers such as 1234,
  > > >1245, 1267 etc. I want this so that we don't have
  > to run the report 20
  > > >times
  > > >for 20 different numbers, we just paste in a list
  > of numbers and the
  > report
  > > >runs for that list.
  > > >
  > > >Can this be done? If so, how and what is the
  > syntax??
  > > >
  > > >Thanks
  > > >Peter
  > >
  > >________________________________________________________________________
  > > >Get Your Private, Free E-mail from MSN Hotmail at
  > http://www.hotmail.com
  > > >
  > > >--
  > > >Author: Peter Hazelton
  > > > INET: peterhazelton_at_hotmail.com
  > > >
  > > >Fat City Network Services -- (858) 538-5051
  > FAX: (858) 538-5051
  > > >San Diego, California -- Public Internet
  > access / Mailing Lists
  > >
  > >--------------------------------------------------------------------
  > > >To REMOVE yourself from this mailing list, send
  > an E-Mail message
  > > >to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > > >the message BODY, include a line containing:
  > UNSUB ORACLE-L
  > > >(or the name of mailing list you want to be
  > removed from). You may
  > > >also send the HELP command for other information
  > (like subscribing).
  > > >
  > > >--
  > > >Author: William Beilstein
  > > > INET: BeilstWH_at_obg.com
  > > >
  > > >Fat City Network Services -- (858) 538-5051
  > FAX: (858) 538-5051
  > > >San Diego, California -- Public Internet
  > access / Mailing Lists
  > >
  > >--------------------------------------------------------------------
  > > >To REMOVE yourself from this mailing list, send
  > an E-Mail message
  > > >to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > > >the message BODY, include a line containing:
  > UNSUB ORACLE-L
  > > >(or the name of mailing list you want to be
  > removed from). You may
  > > >also send the HELP command for other information
  > (like subscribing).
  > >
  > >
  >

  ---

  
  > > Get Your Private, Free E-mail from MSN Hotmail at
  > http://www.hotmail.com
  > >
  > > --
  > > Author: Peter Hazelton
  > > INET: peterhazelton_at_hotmail.com
  > >
  > > Fat City Network Services -- (858) 538-5051
  > FAX: (858) 538-5051
  > > San Diego, California -- Public Internet
  > access / Mailing Lists
  > >
  >

  ---

  
  > > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > > (or the name of mailing list you want to be
  > removed from). You may
  > > also send the HELP command for other information
  > (like subscribing).
  > >
  >
  > --
  > Author: Sophie Schaaf
  > INET: eschaaf_at_goodegg.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > (or the name of mailing list you want to be removed
  > from). You may
  > also send the HELP command for other information