OraFAQ Forum: Reports & Discoverer » How to run the report with two ore more values in a user parameter?

Home » Developer & Programmer » Reports & Discoverer » How to run the report with two ore more values in a user parameter?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to run the report with two ore more values in a user parameter? [message #269452]

Sat, 22 September 2007 07:21

florencekiu
Messages: 2
Registered: September 2007

Junior Member

I'm using Reports 2.5 version.
I define a user parameter called p_no and would like to enter more than one value when running the report. But I found that the parameter only can accept one value (e.g p_no = 17). If I enter two value (e.g p_no = 23,17), it's failed. How can I enter two or more value each time?

SQL statment as follow:
select * from supplier where number in (:p_no);

[Updated on: Sat, 22 September 2007 08:11]

Report message to a moderator

Re: How to run the report with two ore more values in a user parameter? [message #269472 is a reply to message #269452]

Sat, 22 September 2007 13:03

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Try to use lexical parameter instead of bind one.

By
Vamsi

Report message to a moderator

Re: How to run the report with two ore more values in a user parameter? [message #269569 is a reply to message #269472]

Sun, 23 September 2007 09:52

florencekiu
Messages: 2
Registered: September 2007

Junior Member

How to use lexical parameter in Oracle Reports 2.5?

Thanks,
florencekiu

Report message to a moderator

Re: How to run the report with two ore more values in a user parameter? [message #269575 is a reply to message #269569]

Sun, 23 September 2007 10:47

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Have you searched google?
how about this one?

One of the easy ways to get the answer quickly:
Search first.
Please follow OraFAQ Forum Guide.

Just below you can see another thread on lexical parameters. Have you taken a look? I don't know whether difference in release does matter in this or not.

By
Vamsi

[Updated on: Sun, 23 September 2007 10:52]

Report message to a moderator

Re: How to run the report with two ore more values in a user parameter? [message #269585 is a reply to message #269575]

Sun, 23 September 2007 12:04

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Another possiblity is to create two parameters instead of one and rewrite the query so that it looks like

SELECT * FROM supplier
WHERE (number = :p1_no
       OR
       number = :p2_no
      )

Report message to a moderator

Re: How to run the report with two ore more values in a user parameter? [message #269601 is a reply to message #269585]

Sun, 23 September 2007 14:32

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Yes, but only works for two values.
We have to define those many parameters as many we want to put them after IN.

Of course, OP was for two only.

By
Vamsi

Report message to a moderator

Previous Topic:	Matrix Report
Next Topic:	How to create Drill down report in reports 10g ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 04 12:07:13 CDT 2024