| how to pass multiple user parameters - forms10g to reports10g [message #152142] |
Wed, 21 December 2005 06:43  |
ddshah
Messages: 16
Registered: December 2005
|
Junior Member |
|
|
I tried to quickly find this orafaq & other doc - but couldn't find much on using parameter list and pl_id i.e. using parameter object id passing from forms to reports (both of ids10g)
can any one highlight
how to pass multiple user parameters - forms10g to reports10g
will i need to hard code the following is showing only one
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_OTHER,'paramform=no rp_sb_id='||:sb_id);
for two parameters
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_OTHER,'paramform=no rp_sb_id='||:sb_id || ' rp_item=' || :item );
how to pass pl_id which we used to do in 6i forms & reports
using run_report_object and web.show_document
is this possible? somewhere i read about hidden variable -- what is?
Any help - Thanks.
|
|
|
|
| Re: how to pass multiple user parameters - forms10g to reports10g [message #152227 is a reply to message #152142] |
Wed, 21 December 2005 15:19  |
ddshah
Messages: 16
Registered: December 2005
|
Junior Member |
|
|
I found one solution is working that you keep concatinating one user parameter to another - and make one long string --- instead of old way of paramlist id passing..
But I have one problem - I am passing condition parameter -which i am using in my report query -the code is as follows
this is not working it's giving err FRM-41214 and REP-159
vcond := 'where (substr(a.acno,1,length(:pstacno)) >= :pstacno and substr(a.acno,1,length(:pedacno)) <= :pedacno )';
Is it because of = sign ?
Any Help - Thanks.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
