| Report Parameter Problem [message #153310] |
Sat, 31 December 2005 03:53  |
HossainDhaka
Messages: 2
Registered: December 2005
|
Junior Member |
|
|
Dear Experts,
Assume table and data like
--------------------------
P_CODE|NAME_of_product
-------------------------
AD2 |Adora capsule 20gm
PN4 |Pintonix 40 mg Tablet
AC2 |Acuren 25 mg Tablet
---------------------------------
I want to display a report where user will input value of P_CODE as paramert. Input like PN4,AD2 and report will display Name_of_product.
My problem is, I cant user more then one value in a single parameter. OR how I can user following SQL
(select p_code,name_of_product from product where p_code in(:p_1));
here :p_1 parameter should contain ('AD2','AC2') then I can get desired output of
Adora capsule 20gm
Acuren 25 mg Tablet
I am in big problem. Pls help me
Robin
|
|
|
|
|
|
| Re: Report Parameter Problem [message #153379 is a reply to message #153310] |
Sun, 01 January 2006 23:31  |
mvbhavsar
Messages: 3
Registered: April 2005
Location: Pune
|
Junior Member |
|
|
Hi,
This problem can be sorted out very easily. Just use lexical parameters. Lexical parameters are the parameter which replaces clause like entire where clause or can replace entire SQL query.
just go through lexical parameter docs. Do write to me if you are facing any more problem.
Manish
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
