Home » Developer & Programmer » Forms » Run a report in web layout
Run a report in web layout [message #303663] Sat, 01 March 2008 14:27 Go to next message
nclody
Messages: 3
Registered: March 2008
Location: Bucharest, Romania
Junior Member

Hello everybody,

I need to create a button which will launch a .jsp report in web layout. I've successfully created one button that launch the report in paper layout.

Please tell me if this is possible and if yes ...how?

Thanks,
Claudiu

PS as you may already guessed i am a completely newbie so please ask anything that you think it's necessary before giving a solution.

I am using a 10.2.0.1.0 database and developer 10.1.2.0.2 on win2003 sp2
Re: Run a report in web layout [message #303683 is a reply to message #303663] Sat, 01 March 2008 23:39 Go to previous messageGo to next message
dbhossain
Messages: 155
Registered: August 2007
Location: Dhaka
Senior Member

hi,

Now create a button and type code under "WHEN-BUTTON-PRESSED as


-------------------------
web.show_document('/reports/rwservlet?userid=scott/tiger@orcl destype=cache desformat=pdf&server=newserver&paramform=no&MODULE=D:\myreport.rdf',' ');
-------------------------

------------
dbhossain
Re: Run a report in web layout [message #303691 is a reply to message #303683] Sun, 02 March 2008 01:24 Go to previous messageGo to next message
nclody
Messages: 3
Registered: March 2008
Location: Bucharest, Romania
Junior Member

dbhossain wrote on Sun, 02 March 2008 07:39
hi,

Now create a button and type code under "WHEN-BUTTON-PRESSED as


-------------------------
web.show_document('/reports/rwservlet?userid=scott/tiger@orcl destype=cache desformat=pdf&server=newserver&paramform=no&MODULE=D:\myreport.rdf',' ');
-------------------------

------------
dbhossain



Thanks for the info, but unfortunately this doesn't solve my problem. Creating a button with that code will also show the report in paper layout.

Any other ideas?

Thanks
Re: Run a report in web layout [message #303693 is a reply to message #303691] Sun, 02 March 2008 01:49 Go to previous messageGo to next message
Littlefoot
Messages: 20895
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Check this document (Integrating Oracle Reports in Oracle Forms Services applications); perhaps you'll find it useful.
Re: Run a report in web layout [message #303712 is a reply to message #303663] Sun, 02 March 2008 04:42 Go to previous message
nclody
Messages: 3
Registered: March 2008
Location: Bucharest, Romania
Junior Member

Problem solved:

I've created a new button with 'when button pressed' trigger:
WEB.SHOW_DOCUMENT('http://server1:8889/reports/report.jsp?userid=user/password@orcl','_blank');

For this command to work, I've copied the report.jsp file in %DEVHOME\reports\j2ee\reports_ids\web\ folder.


Thanks everyone for support.

Regards,
Claudiu
Previous Topic: HOW I CAN DO THIS ?
Next Topic: How to Disable Message on the Forms
Goto Forum:
  


Current Time: Mon Dec 05 18:53:56 CST 2016

Total time taken to generate the page: 0.10543 seconds