Home » Developer & Programmer » Forms » Call Report from Form (10g form builder,11gdb)
Call Report from Form [message #586266] Wed, 05 June 2013 02:12 Go to next message
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 #586270 is a reply to message #586266] Wed, 05 June 2013 02:29 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It seems that quotes make the difference.

Does the report work OK when you run it from Reports Builder (using the same "invalid" parameters, such as UBS 2" MD)? I suppose not. Therefore, could you post report's query so that we could see it?
Re: Call Report from Form [message #586273 is a reply to message #586270] Wed, 05 June 2013 02:35 Go to previous messageGo to next message
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 #586275 is a reply to message #586273] Wed, 05 June 2013 02:40 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
So I was wrong ...

How does a form part of the story look like? How do you pass parameter values to the report?
Re: Call Report from Form [message #586276 is a reply to message #586275] Wed, 05 June 2013 02:43 Go to previous messageGo to next message
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 #586280 is a reply to message #586276] Wed, 05 June 2013 03:00 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't see anything wrong here either. What happens if you enclose parameter into single quotes (chr(39)), such as
ADD_PARAMETER(PL_ID, 'DESCRIPTION', TEXT_PARAMETER, chr(39) || :DESC || chr(39));
Re: Call Report from Form [message #586292 is a reply to message #586280] Wed, 05 June 2013 03:25 Go to previous messageGo to next message
ora_bbm
Messages: 30
Registered: March 2013
Location: Chennai
Member
again it through same error..any other solutions...

thanks......

[Updated on: Wed, 05 June 2013 03:31]

Report message to a moderator

Re: Call Report from Form [message #586297 is a reply to message #586292] Wed, 05 June 2013 03:40 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Try with double quotes as well (honestly, I have no idea what will be the result of double quotes enclosed into another double quotes ...):
ADD_PARAMETER(PL_ID, 'DESCRIPTION', TEXT_PARAMETER, '"' || :DESC || '"');


Could you post URL (from your browser's address line) which is supposed to open a report (version with the above double quotes option)?
Re: Call Report from Form [message #586303 is a reply to message #586297] Wed, 05 June 2013 03:47 Go to previous messageGo to next message
ora_bbm
Messages: 30
Registered: March 2013
Location: Chennai
Member
The above solution through same error
and my URL is
http://ilp-4f442b2805f:8889/forms/frmservlet

anyway thanks for your replies..i will try if i found i will post here..
Re: Call Report from Form [message #586305 is a reply to message #586303] Wed, 05 June 2013 03:50 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This URL is ... well, not what I expected. It doesn't contain report name, parameter name and its value so - if possible, show us that URL.
Re: Call Report from Form [message #586314 is a reply to message #586305] Wed, 05 June 2013 04:00 Go to previous messageGo to next message
ora_bbm
Messages: 30
Registered: March 2013
Location: Chennai
Member
I dont know how to make that URL.
and my report name is arcdesc.rdf
report server is repserver

Could u please reply how to make that URL.
Re: Call Report from Form [message #586316 is a reply to message #586314] Wed, 05 June 2013 04:17 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
When you run the report (although it fails), I hope that there's its URL in browser's address line, something like this:

/forum/fa/10844/0/

It says that report "GLED_ods_ts_redpr" accepts a parameter named "par_id_evid" whose value is 369580 (and another parameter "par_list_..." etc., not visible here).

Re: Call Report from Form [message #586347 is a reply to message #586316] Wed, 05 June 2013 06:25 Go to previous messageGo to next message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Dear,
Quote:

I dont know how to make that URL.
and my report name is arcdesc.rdf
report server is repserver
Could u please reply how to make that URL.

Have a look http://www.orafaq.com/forum/mv/msg/174897/524022/81953/#msg_524022

It'll help you.

Regards,
Irfan

[Updated on: Wed, 05 June 2013 06:26]

Report message to a moderator

Re: Call Report from Form [message #586392 is a reply to message #586305] Thu, 06 June 2013 00:14 Go to previous messageGo to next message
ora_bbm
Messages: 30
Registered: March 2013
Location: Chennai
Member
http://ilp-4f442b2805f:8889/reports/rwservlet?
userid=scott/tiger@11gdb&server=Repserver&report=E:\bala\test.rdf&destype=CACHE&desformat=html

[Updated on: Thu, 06 June 2013 00:15]

Report message to a moderator

Re: Call Report from Form [message #586393 is a reply to message #586392] Thu, 06 June 2013 00:30 Go to previous message
Littlefoot
Messages: 21806
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).
Previous Topic: download
Next Topic: How to export Data to excel oracle forms
Goto Forum:
  


Current Time: Fri Mar 29 00:28:46 CDT 2024