OraFAQ Forum: Forms » Run a report in web layout

Home » Developer & Programmer » Forms » Run a report in web layout

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Run a report in web layout [message #303663]

Sat, 01 March 2008 14:27

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

Report message to a moderator

Re: Run a report in web layout [message #303683 is a reply to message #303663]

Sat, 01 March 2008 23:39

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

Report message to a moderator

Re: Run a report in web layout [message #303691 is a reply to message #303683]

Sun, 02 March 2008 01:24

nclody
Messages: 3
Registered: March 2008
Location: Bucharest, Romania

Junior Member

dbhossain wrote on Sun, 02 March 2008 07:39

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

Report message to a moderator

Re: Run a report in web layout [message #303693 is a reply to message #303691]

Sun, 02 March 2008 01:49

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Run a report in web layout [message #303712 is a reply to message #303663]

Sun, 02 March 2008 04:42

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

Report message to a moderator

Previous Topic:	HOW I CAN DO THIS ?
Next Topic:	How to Disable Message on the Forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 10 19:52:26 CDT 2025