OraFAQ Forum: Forms » Call Report from Form

Home » Developer & Programmer » Forms » Call Report from Form (10g form builder,11gdb)

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

Call Report from Form [message #586266]

Wed, 05 June 2013 02:12

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

Littlefoot
Messages: 21823
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?

Report message to a moderator

Re: Call Report from Form [message #586273 is a reply to message #586270]

Wed, 05 June 2013 02:35

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...

Report message to a moderator

Re: Call Report from Form [message #586275 is a reply to message #586273]

Wed, 05 June 2013 02:40

Littlefoot
Messages: 21823
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?

Report message to a moderator

Re: Call Report from Form [message #586276 is a reply to message #586275]

Wed, 05 June 2013 02:43

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;

Report message to a moderator

Re: Call Report from Form [message #586280 is a reply to message #586276]

Wed, 05 June 2013 03:00

Littlefoot
Messages: 21823
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));

Report message to a moderator

Re: Call Report from Form [message #586292 is a reply to message #586280]

Wed, 05 June 2013 03:25

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

Littlefoot
Messages: 21823
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)?

Report message to a moderator

Re: Call Report from Form [message #586303 is a reply to message #586297]

Wed, 05 June 2013 03:47

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..

Report message to a moderator

Re: Call Report from Form [message #586305 is a reply to message #586303]

Wed, 05 June 2013 03:50

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Call Report from Form [message #586314 is a reply to message #586305]

Wed, 05 June 2013 04:00

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.

Report message to a moderator

Re: Call Report from Form [message #586316 is a reply to message #586314]

Wed, 05 June 2013 04:17

Littlefoot
Messages: 21823
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/

/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).

Attachment: report_url.JPG
(Size: 15.29KB, Downloaded 1627 times)

Report message to a moderator

Re: Call Report from Form [message #586347 is a reply to message #586316]

Wed, 05 June 2013 06:25

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

ranamirfan@gmail.com

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

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

Littlefoot
Messages: 21823
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).

Report message to a moderator

Previous Topic:	download
Next Topic:	How to export Data to excel oracle forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 00:58:46 CST 2025