Home » Developer & Programmer » Forms » REPORT NOT RUNNING AS SHOULD WHEN HANGING THROUGH A FORM (ORACLE FORMS AND REPORTS 10G)
REPORT NOT RUNNING AS SHOULD WHEN HANGING THROUGH A FORM [message #636001] Tue, 14 April 2015 07:31 Go to next message
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 Go to previous messageGo to next message
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...
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 Go to previous messageGo to next message
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;
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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...


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 Go to previous message
ORA2015
Messages: 49
Registered: March 2015
Member
10g
Previous Topic: CREATE ALERT
Next Topic: Please Help :(
Goto Forum:
  


Current Time: Wed Nov 25 22:29:38 CST 2020