Call Report from Form [message #586266] |
Wed, 05 June 2013 02:12 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ora_bbm
Messages: 30 Registered: March 2013 Location: Chennai
|
Member |
|
|
Hi
i have one report with one parameter name is :description
the data of the description is
ALL 1" MD
UBS 2" MD
MNC 23 MSD
LKT 11" WIP
LLP 2 MC
and my question is when i call a report from form it shows the syntax error or command line.
if i give the value MNC 23 MSD (or) LLP 2 MC in forms it run good.
But if i give UBS 2" MD (or) ALL 1"MD (or) LKT 11" WIP in forms it through REP-159 Syntax error or command line.
can u please help me...
thanks in advance...
[Updated on: Wed, 05 June 2013 02:13] Report message to a moderator
|
|
|
|
Re: Call Report from Form [message #586273 is a reply to message #586270] |
Wed, 05 June 2013 02:35 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ora_bbm
Messages: 30 Registered: March 2013 Location: Chennai
|
Member |
|
|
Query:
select * from ppc where description=:description
This report runs in report builder good for both values like UBS 2" MD and
MNC 23 MSD.
but in form builder it through error for this value USB 2" MD.
any solutions....
thanks...
|
|
|
|
Re: Call Report from Form [message #586276 is a reply to message #586275] |
Wed, 05 June 2013 02:43 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ora_bbm
Messages: 30 Registered: March 2013 Location: Chennai
|
Member |
|
|
This is my codings to pass parameters:
DECLARE
V_REPID REPORT_OBJECT;
PL_ID PARAMLIST;
BEGIN
PL_ID := CREATE_PARAMETER_LIST('TEMPDATA');
ADD_PARAMETER(PL_ID,'DESCRIPTION',TEXT_PARAMETER,:DESC);
V_REPID := FIND_REPORT_OBJECT('REP');
WEB_REPORT(V_REPID,PL_ID);
DESTROY_PARAMETER_LIST('TEMPDATA');
END;
|
|
|
|
|
|
|
|
|
|
|
|
Re: Call Report from Form [message #586393 is a reply to message #586392] |
Thu, 06 June 2013 00:30 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
There's no report parameter (DESC, right?) in this URL, which is the most important part of it (as far as this discussion is concerned of).
|
|
|