OraFAQ Forum: Forms » running report from form

Home » Developer & Programmer » Forms » running report from form

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

running report from form [message #264210]

Sun, 02 September 2007 01:00

sd_md_rizwan@yahoo.com
Messages: 37
Registered: September 2007
Location: Saudi Arabia

Member

how can i run a report from my from

Report message to a moderator

Re: running report from form [message #264211 is a reply to message #264210]

Sun, 02 September 2007 01:11

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

Report message to a moderator

Re: running report from form [message #264911 is a reply to message #264211]

Wed, 05 September 2007 00:37

danishayder
Messages: 6
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

Report message to a moderator

Re: running report from form [message #265999 is a reply to message #264911]

Sat, 08 September 2007 14:41

sams
Messages: 100
Registered: August 2007

Senior Member

search this forum.you will get deatil stuff related to running report from a form.

Report message to a moderator

Re: running report from form [message #266475 is a reply to message #264210]

Tue, 11 September 2007 00:10

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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 04:24:34 CDT 2024