OraFAQ Forum: Forms » Unable to generate Reports

Home » Developer & Programmer » Forms » Unable to generate Reports (10g forms and reports, Windows server 2003)

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

Unable to generate Reports [message #490433]

Tue, 25 January 2011 01:25

sankalputtara
Messages: 53
Registered: January 2011
Location: Bangalore

Member

Hi everyone. This is my 1st post so kindly excuse me if i have missed to follow any rules of this forum.

I am using the following code to generate my report

pat:= :global.path||'us01127p4';
run_report('heboracle1.pace.internal:7778',
'r1',pat,'c:\','c:\','pdf','pacerep',pl_id,'yes',
'&co_code='||:global.co_code||'&type_sl='||mtype_sl||'&prog_sl='||:global.prog_sl||'&mode='||'default'||'&desname ='||:global.user_fname||'&destype='||'cache'||
'&to_no='||:to_doc_no||'&year='||myear||'&from_no='||:from_doc_no,'no','no','','wide180');

When i set my param form variable as 'Yes' the report parameters window pops up and when i press submit query the report gets generated.
But if i set param form to 'No' then i get a msg saying

TERMINATED_WITH_ERROR-Report output aborted ORA-0000
if i put an exception i am getting a same msg.

The same code is working fine for other forms.
I am new to this domain. Kindly help me at the earliest.

Thanks in Advance Smile

Report message to a moderator

Re: Unable to generate Reports [message #490439 is a reply to message #490433]

Tue, 25 January 2011 02:05

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

Sounds like the problem is the report not the form. It can't run without it's param form.

Report message to a moderator

Re: Unable to generate Reports [message #490464 is a reply to message #490439]

Tue, 25 January 2011 04:07

sankalputtara
Messages: 53
Registered: January 2011
Location: Bangalore

Member

@cookiemonster: any idea where the issue might be in the report.(Generally/ By your experience)

Report message to a moderator

Re: Unable to generate Reports [message #490466 is a reply to message #490464]

Tue, 25 January 2011 04:10

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

Never hit anything like that before. Got any validation triggers on the param form? Or an after-paramform?

EDIT: typo

[Updated on: Tue, 25 January 2011 04:11]

Report message to a moderator

Re: Unable to generate Reports [message #490474 is a reply to message #490466]

Tue, 25 January 2011 04:33

sankalputtara
Messages: 53
Registered: January 2011
Location: Bangalore

Member

Yes i have got a before report trigger and few formula validation. But they are the same for most of the reports and they are all working fine.

Report message to a moderator

Re: Unable to generate Reports [message #490478 is a reply to message #490474]

Tue, 25 January 2011 04:56

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Did you try to recompile all (Ctrl + Shift + K)?

Is paramform parameter set to 'no' or 'no ' (a space in front of / behind / around "no") (if it makes any difference)?

Report message to a moderator

Re: Unable to generate Reports [message #490485 is a reply to message #490478]

Tue, 25 January 2011 05:10

sankalputtara
Messages: 53
Registered: January 2011
Location: Bangalore

Member

Yes. When i compile the forms and reports i won't get any errors. I actually paste the .rdf and .fmx files in another directory from where the files are fetched. And i am very sure that there is no space front of / behind / around "no".
The funniest thing is when i set it to 'yes' the report works perfectly.
I am breaking my head on this issue from 3days which appears to be so silly Razz

(if it helps: i have converted the reports from 6i to 10g)

Report message to a moderator

Previous Topic:	issue with a database item in a block/canvass
Next Topic:	stacked canvas disappear

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 10 01:37:52 CST 2025