Home » Developer & Programmer » Forms » Link between forms and reports
Link between forms and reports [message #144011] Mon, 24 October 2005 11:12 Go to next message
Niranjan_1983
Messages: 12
Registered: June 2005
Location: Chennai
Junior Member
1.I need to transfer a form parameter value into report parameter
2. If it is not possible when i call report from from i need to hide the parameter form in the report will you be kind enough to help me ot in solvin the above
Re: Link between forms and reports [message #144065 is a reply to message #144011] Mon, 24 October 2005 21:22 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Search this forum for 'report' and 'parameter'. This question has been answered before.

In your Report Builder, at the highest level of the report, in the properties sheet, I believe there is a 'Parameter Form'=Yes/No attribute. Make it 'No'.

David
Re: Link between forms and reports [message #192879 is a reply to message #144011] Thu, 14 September 2006 01:22 Go to previous messageGo to next message
Niranjan_1983
Messages: 12
Registered: June 2005
Location: Chennai
Junior Member
It is not possible to hide a prameter form used in reports

[Updated on: Thu, 14 September 2006 01:22]

Report message to a moderator

Re: Link between forms and reports [message #192895 is a reply to message #192879] Thu, 14 September 2006 02:32 Go to previous message
sandeepk7
Messages: 137
Registered: September 2006
Senior Member

Try this code
begin
pl_id:=get_parameter_list('tempdata');
if not id_null(pl_id) then
destroy_parameter_list(pl_id);
end if;
pl_id:=create_parameter_list('tempdata');
/* use below code to pass parameter from form to report. here parameter1 is name of parameter defined in Report and :text_item is item which contains the value which is to be passed */

add_parameter(pl_id,'parameter1',text_parameter,:text_item);
/* to hide parameter form at runtime */

add_parameter(pl_id,'PARAMFORM',text_parameter,'NO');
run_product(reports,'Report_name',synchronous,runtinme,filesystem,pl_id,");
end;


Sandy
Previous Topic: Update on database through forms compilation Error!
Next Topic: grant issue
Goto Forum:
  


Current Time: Sun Dec 04 22:52:14 CST 2016

Total time taken to generate the page: 0.05265 seconds