Home » Developer & Programmer » Forms » running report from form
running report from form [message #264210] Sun, 02 September 2007 01:00 Go to next message
sd_md_rizwan@yahoo.com
Messages: 37
Registered: September 2007
Location: Saudi Arabia
Member

how can i run a report from my from
Re: running report from form [message #264211 is a reply to message #264210] Sun, 02 September 2007 01:11 Go to previous messageGo to next message
bbaz
Messages: 138
Registered: April 2007
Senior Member
Search this Forum, you will find plenty of examples and topics on this subject.

Try the following:

message #242768, message #241344, message #232561

Hope this helps,
Baz
Re: running report from form [message #264911 is a reply to message #264211] Wed, 05 September 2007 00:37 Go to previous messageGo to next message
danishayder
Messages: 5
Registered: September 2006
Location: Karachi
Junior Member

use Run_product built in

example
Run_Product(REPORTS, 'LE_M5030.REP', SYNCHRONOUS, RUNTIME, FILESYSTEM,'NulL');

Regards
Danish Hayder
Re: running report from form [message #265999 is a reply to message #264911] Sat, 08 September 2007 14:41 Go to previous messageGo to next message
sams
Messages: 100
Registered: August 2007
Senior Member
search this forum.you will get deatil stuff related to running report from a form.
Re: running report from form [message #266475 is a reply to message #264210] Tue, 11 September 2007 00:10 Go to previous message
dbhossain
Messages: 155
Registered: August 2007
Location: Dhaka
Senior Member

Follow this command to run a report from
Developer 10g forms:

first you have to run the report server:

Step-1: to install and run report server

go to the commandprompt

C:\rwserver -install newserver

-- here newserver is the server name , you
---can change it to your own name.

after this you will be showan a message and then
go to control panel>administrative tools > services
you can see your server name "newserver" in the list.
double click to open and start it and set automatically.

now back to your Forms from where you wanna call the report.

type following code:

when_button_pressed

---------------------------
web.show_document('/reports/rwservlet?userid=bsticm/bsti@mkh destype=cache desformat=pdf&speiil&P_STATUS='||:LDI||'&P_DIVISION='||:DIV||'&MODULE=D:\BSTICM_REPORTSHOUSE\DIV_LDI',' ');

---------------------------------------------------
Note: here speiil is my variable that contians the value.
speiil=server=newserver&paramform=no
so you can put server=newserver&paramform=no inplace of speiil.


note: here mkh is my SID name
bsticm is the database user name
bsti is the database user password.
P_STATUS, P_DIVISION is the parameter send to the
report. if you do not have parameter then you can
skip it.
BSTICM_REPORTHOUSE is the folder in drive D
and DIV_LDI is the report name that to run.

Instruction: if you want to view the report in PDF format, you must have Acrobat Reader installed.
please follow this, i think it will run.


Thank you.
Previous Topic: Listitem not populating correctly
Next Topic: How to kill EXCEL.exe from Task Manager from Oracle Forms?
Goto Forum:
  


Current Time: Tue Dec 06 12:36:19 CST 2016

Total time taken to generate the page: 0.14822 seconds