Home » Developer & Programmer » Forms » Problem(Call reports from oracle forms) (Oracle forms 10g)
Problem(Call reports from oracle forms) [message #501057] Fri, 25 March 2011 08:04 Go to next message
Dikshit
Messages: 8
Registered: March 2011
Location: Ludhiana
Junior Member
sir,
I have problem.I don't know how to call oracle reports from oracle forms ...Plz help Sad
Re: Problem(Call reports from oracle forms) [message #501082 is a reply to message #501057] Fri, 25 March 2011 12:20 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It has been discussed previously; here are the search results. Check what's already being said, feel free to search further by yourself.
Re: Problem(Call reports from oracle forms) [message #501128 is a reply to message #501082] Sat, 26 March 2011 02:26 Go to previous messageGo to next message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Dear,
Web.Show_Document('http://hoitvoltes5:9002/reports/rwservlet?userid=nisadmin/nisadmin@abc&server=ReportsServer_HOITVOLTES5_asin&report=F:\xyz.rdf&destype=CACHE&desformat=htmlcss&paramform=no','_blank');


With Two Report Parameters ( Company ID, Voucher No ).


Declare
v_connect	VARCHAR2 (200)  := 'userid=nisadmin/nisadmin@abc';
v_report_name	VARCHAR2(100)   := 'Voucher.rdf';
v_format	VARCHAR2(12)    :='Htmlcss';
 
Begin

Web.Show_Document('http://hoitvoltes5:9002/reports/rwservlet?'||v_connect||'&server=ReportsServer_HOITVOLTES5_asin&destype=cache&report='||v_report_name||'&desformat='||v_format||'&companyid='||:voucher.companyid||'&vouno='||:voucher.vouno,'_blank');

End;




Hope it'll help you.

Regards,

Irfan

[Updated on: Sat, 26 March 2011 02:28]

Report message to a moderator

Re: Problem(Call reports from oracle forms) [message #501993 is a reply to message #501128] Sat, 02 April 2011 07:14 Go to previous message
zishan
Messages: 1
Registered: September 2007
Location: Karachi
Junior Member
Thanks Sir
please give me idea about how to call report from form 10g with paperlayout style instead of web layout.

thanks in advance
Zishan
Previous Topic: char display right to left
Next Topic: creating menu in 10g
Goto Forum:
  


Current Time: Mon Sep 16 12:56:46 CDT 2024