Home » Developer & Programmer » Reports & Discoverer » Pass parameter from forms to Report (Very Urgent) (Windows 2003 Server)
Pass parameter from forms to Report (Very Urgent) [message #597534] Sat, 05 October 2013 13:32 Go to next message
reaz62
Messages: 15
Registered: December 2012
Location: dhaka
Junior Member
I can not Pass parameter from forms to Report

I use three parameter for report. I want to show the employee who has been hired between from_date to_date,it work well in report builder. but I want to pass parameter from forms to report and pdf format. I upload my work (this is acutally a zip File, please change file type txt to zip just before open).

Please Help,
  • Attachment: practice.txt
    (Size: 25.64KB, Downloaded 1769 times)
Re: Pass parameter from forms to Report (Very Urgent) [message #597538 is a reply to message #597534] Sat, 05 October 2013 16:15 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Which Forms & Reports version do you use?

How exactly did you pass parameters from a form to a report? Did you do that (or are you just asking HOW to do it)?
Re: Pass parameter from forms to Report (Very Urgent) [message #597540 is a reply to message #597538] Sat, 05 October 2013 21:06 Go to previous messageGo to next message
reaz62
Messages: 15
Registered: December 2012
Location: dhaka
Junior Member
I am asking HOW to do it? please make this form functional and mail me(reaz62@yahoo.com) the source code.
thanks and best Regards
Reaz
Re: Pass parameter from forms to Report (Very Urgent) [message #597543 is a reply to message #597540] Sun, 06 October 2013 01:01 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Sorry, that's not going to happen (i.e. me creating a form for you, but someone else might).

Research use of "creating parameter list" built-ins (here is a nice page that explains them all). Then you'll be able to research some more as you'd know keywords (such as "oracle add_parameter run report" which returns, for example, Run Oracle Reports from Oracle Forms).

Re: Pass parameter from forms to Report (Very Urgent) [message #597565 is a reply to message #597540] Sun, 06 October 2013 13:06 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
reaz62 wrote on Sun, 06 October 2013 07:36
make this form functional and mail me(reaz62@yahoo.com) the source code.


Are you serious? Did you say the same lines to your technical/module lead/Boss? This is not the way to seek help in any forum.
Re: Pass parameter from forms to Report (Very Urgent) [message #602305 is a reply to message #597565] Mon, 02 December 2013 22:37 Go to previous message
shahzad-ul-hasan
Messages: 615
Registered: August 2002
Senior Member
Kindly view that...to pass parameter from forms to Report....
declare
  pl_id ParamList; 
BEGIN 
  pl_id := Get_Parameter_List('tmpdata'); 
  IF NOT Id_Null(pl_id) THEN 
    Destroy_Parameter_List( pl_id ); 
  END IF; 
  
  pl_id := Create_Parameter_List('tmpdata'); 

 add_parameter(pl_id,'CODE1',TEXT_PARAMETER,:ACC_CODE1);
 add_parameter(pl_id,'CODE2',TEXT_PARAMETER,:ACC_CODE2);
 add_parameter(pl_id,'DATE1',TEXT_PARAMETER,TO_CHAR(:DATE1,'DDMMRRRR'));
 add_parameter(pl_id,'DATE2',TEXT_PARAMETER,TO_CHAR(:DATE2,'DDMMRRRR'));
 add_parameter(pl_id,'FOR_UNIT',TEXT_PARAMETER,:GLOBAL.UNIT_YEAR_CODE);
		 

Run_Product(REPORTS, 'C:\FINANCE\REPORTS\ACCOUNTS_STATEMENT.REP', SYNCHRONOUS, RUNTIME,FILESYSTEM, pl_id, NULL); 
end;

/forum/fa/11344/0/
  • Attachment: acc.JPG
    (Size: 18.04KB, Downloaded 1966 times)
Previous Topic: oracle report 10g log
Next Topic: master-detail report
Goto Forum:
  


Current Time: Thu Mar 28 15:43:11 CDT 2024