OraFAQ Forum: Forms » REPORT NOT RUNNING AS SHOULD WHEN HANGING THROUGH A FORM

Home » Developer & Programmer » Forms » REPORT NOT RUNNING AS SHOULD WHEN HANGING THROUGH A FORM (ORACLE FORMS AND REPORTS 10G)

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

REPORT NOT RUNNING AS SHOULD WHEN HANGING THROUGH A FORM [message #636001]

Tue, 14 April 2015 07:31

ORA2015
Messages: 49
Registered: March 2015

Member

Hello,
I have reports hanging of a main menu form created. When the report is ran by itself parameters are shown as expected. However, when the report is placed on the form and the link is pressed, the parameter form shows all the values of the parameters. How can this be avoided?

[Updated on: Tue, 14 April 2015 07:31]

Report message to a moderator

Re: REPORT NOT RUNNING AS SHOULD WHEN HANGING THROUGH A FORM [message #636050 is a reply to message #636001]

Wed, 15 April 2015 10:19

CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA

Senior Member

Please show us the code used to call the report from your Form.

Craig...

Report message to a moderator

Re: REPORT NOT RUNNING AS SHOULD WHEN HANGING THROUGH A FORM [message #636080 is a reply to message #636050]

Thu, 16 April 2015 06:26

ORA2015
Messages: 49
Registered: March 2015

Member

Hello Craig,

This is the code placed in a when tree node activated trigger under the tree_control item in forms builder:

DECLARE
htree ITEM;
node_value VARCHAR2(100);
report_id Report_Object;
vNode ftree.node;
BEGIN
htree := Find_Item('LAUNCH.TREE_CONTROL');
node_value := Ftree.Get_Tree_Node_Property(htree, :SYSTEM.TRIGGER_NODE, Ftree.NODE_VALUE);
report_id:=FIND_REPORT_OBJECT('reports');

if node_value = 'Apple Form' then
Call_form('\\servappdev\forms\Fruits\forms\Apple.fmx');
end if;
END;

Report message to a moderator

Re: REPORT NOT RUNNING AS SHOULD WHEN HANGING THROUGH A FORM [message #636082 is a reply to message #636050]

Thu, 16 April 2015 06:59

ORA2015
Messages: 49
Registered: March 2015

Member

Hello Craig,

This is the code placed in a when tree node activated trigger under the tree_control item in forms builder:

DECLARE
htree ITEM;
node_value VARCHAR2(100);
report_id Report_Object;
vNode ftree.node;
BEGIN
htree := Find_Item('LAUNCH.TREE_CONTROL');
node_value := Ftree.Get_Tree_Node_Property(htree, :SYSTEM.TRIGGER_NODE, Ftree.NODE_VALUE);
report_id:=FIND_REPORT_OBJECT('reports');

if node_value = 'Apple Report' then
RUN_REPORT(report_id,:GLOBAL.repserv,'pdf',CACHE,:GLOBAL.dir || 'Apple.rdf','paramform=yes','/reports/rwservlet');
end if;
END;

[Updated on: Thu, 16 April 2015 07:01]

Report message to a moderator

Re: REPORT NOT RUNNING AS SHOULD WHEN HANGING THROUGH A FORM [message #636088 is a reply to message #636082]

Thu, 16 April 2015 08:54

CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA

Senior Member

Please take a look at the OraFAQ Forum Guide and make sure you use the "[CODE]" tags when you include code samples in your post. This makes it easier for those of use responding to your post. Smile

What is your Forms/Reports Version?

Based on your code sample, it appears you are sending the wrong arguments to the RUN_REPORT() built-in, but I need to know your Forms/Reports version to be sure.

It looks like you want to run the 'Apple' report (Apple.rdf), but you are sending the Report_ID for the 'Reports' (reports.rdf) instead of the Report_ID for the 'Apple' report.

Craig...

Report message to a moderator

Re: REPORT NOT RUNNING AS SHOULD WHEN HANGING THROUGH A FORM [message #636089 is a reply to message #636088]

Thu, 16 April 2015 08:56

ORA2015
Messages: 49
Registered: March 2015

Member

10g

Report message to a moderator

Previous Topic:	CREATE ALERT
Next Topic:	Please Help :(

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 18:38:56 CDT 2024